Question Locked

automate copying access table to sql server 2005 db

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have a table in MS Access that I would like to copy/import into SQL Server 2005. I would like to automate this process so that it copies the table over on a daily basis. Can someone tell me how this can be done?

Thank you in advance.

2 replies

by jkoehler

If you have have SQL Studio Manager (it might be part of Visual Studio Manager)loading the path below will bring up a wizard that will import dabases into SQL from a whole lot of sources. I your particular case you will need to know source app (Access) the server and location of said DB and server and database name of the SQL DB. In the last step you will be able to select what tables form the source DB are imported.

C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTSWizard.exe

This discussion is closed to new replies.