Access to SQL Servergreenspun.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
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.
-- Anonymous, August 15, 2001