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,
Martin

---

Even in DTS you can change DTS connection properties and task properties programatically.
Else read more about OPENQUERY / OPENROWSET in BOL.

---

Refer this
http://sql-server-performance.com/forum/topic.asp?TOPIC_ID=7850
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

---

]]>