problem with export to access

• Luke-640044

  SSC Rookie

  Points: 42

  More actions

  February 13, 2008 at 1:54 am

  #71567

  Hi

  I have a excel file that I import into sqlserver. then I execute a sql task

  to alter some data. after this task I want to export the data to access

  database. How can I tell the DTS to export to access when the sql task has

  completed?

  thanks

• Perry Harts

  Ten Centuries

  Points: 1271

  More actions

  February 13, 2008 at 7:51 am

  #777838

  You should be able to do all of the above in one DTS.

• Sugesh Kumar

  One Orange Chip

  Points: 27311

  More actions

  February 13, 2008 at 8:27 am

  #777866

  You can create a DTS package to tell SQL Server to import data from excel to sql server, then do the data changes and then export it to access. This can be easily done using DTS or SSIS.

  Cheers,
  Sugeshkumar Rajendran
  SQL Server MVP
  http://sugeshkr.blogspot.com

• Erik Kutzler

  SSCarpal Tunnel

  Points: 4287

  More actions

  February 14, 2008 at 10:49 am

  #778482

  Simply add another Data Transformation task to your DTS package after your SQL task. The source of the tranformation would be your SQL Server and the destination would be your Access database.