Copying a file from Database Server??

bobb_roof · 03-20-2007, 09:48 PM

In our w2k3 LAN, My data (an XXX file) resides in a database server (MS SQL Server 2000). i do access and work with this file from an XP workstation (Laptop). Usually i must access the server to get to this file, so the question is how do i make a copy of this file in the local station so that i can work on this XXX file with my notebook while on a trip?

Crito · 03-21-2007, 05:09 AM

You can use MS Access and import the data or you can install the developer edition of SQL Server and simply attach your existing database files.

bobb_roof · 03-22-2007, 05:51 AM

thanks Crito, but in my MS application when i open it, i simply cannot see an option for IMPORT from the File Menu and even from all the Main Menu, Tool Box, etc. can you give me a clearer way of doing this import?

Crito · 03-22-2007, 09:08 AM

I don't have Windows in front of me ATM, but you need to import it into something, so create an empty database first. Then I believe the menu item was called "get external data", under which you had the options to "import" or "link".