Post reply

problem with export to access

  • 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

  • February 13, 2008 at 7:51 am

    #777838

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

  • 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

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

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply