Access to SQL Server

greenspun.com : LUSENET : SQL Server Database Administration : One Thread

Hi, I'd really appreciate it if someone could help me... I'm have to convert Access Databases to SQL Server Databases but I don't really know how to do it and where to start. Somebody got any advice - tip - documentation ??? Thank you.

-- Anonymous, July 29, 2001

Answers

It really depends on what version of SQL Server you are using. I am not sure about 6.5 but with 7.0 and 2000 it is a simple matter of creating your database and then using the import wizard. I would suggest you use books online and read up on "DTS Import/Export Wizard" to guide you through this process. It is painless and fairly easy to do.

Good luck.

-- Anonymous, August 15, 2001


Moderation questions? read the FAQ