SOT: Automatically move Access data to SQL Server 2005

[mjfour]

Hi all,

I hope this is not too off topic. Does any one know of a methodology to automatically move Access data to SQL Server 2005?

Here is the scenario. The Client is syncing their AS400 to Access. They want to upload the Access db to the server and then run a routine to basically purge the tables and repopulate them with the Access data.

My first suggestion was to just do this manually, Second to write a CF routine, but then they asked about something at the SQL level.

Any thoughts are welcome.

Thank you,
Michael

[Xuan_Mai]

You can use 2005 to import data directy from Access using the Import/Export wizard.

http://www.databasejournal.com/features/mssql/article.php/3580216

If you have ever worked with DTS from SQL Server 2000, it is similar but they changed the location and the name.