SQL Server Performance

transfer data from SQL Server to Access.

Discussion in 'SQL Server DTS-Related Questions' started by martin@captivasystems.com, Jul 19, 2005.

  1. 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.

  2. ranjitjain New Member

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

  4. dineshasanka Moderator

    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

Share This Page