transfer data from SQL Server to Access. | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

transfer data from SQL Server to Access.

I need a to write a scrip that does the same as the DTS: transfer data in tables from sql to access. The reason I don’t use the DTS UI is because the tables will not always be the same. I want to be able to do this programmatically, so that the windows application user can create an access database from an existing SQL server. Thanks,
Even in DTS you can change DTS connection properties and task properties programatically.
Else read more about OPENQUERY / OPENROWSET in BOL.
Refer this
Madhivanan Failing to plan is Planning to fail
if you know ADO and VB then you can write simple code to create database and indert data into them if you don’t want to use DTS