Idea to transfer data from sql DB to access and download

• ppa-186269

  Old Hand

  Points: 378

  More actions

  May 19, 2005 at 9:53 pm

  #167042

  Hi

        I'm planning to do the data transfer through sql to access. Then the results should be downloadable format and users should download it. How can i run within the source code?Give me an idea please.

  Thanks in advance.

• jfb

  SSCrazy

  Points: 2469

  More actions

  May 20, 2005 at 8:41 am

  #560222

  You can probably create a vb.net program to execute you DTS pkg, this app can be distribute to the users hiding connection and passwords.

  Here is an example how to execute dts from vb.net

  http://www.sqldev.net/dts/DotNETCookBook.htm

  Rgds

  Johnny