Post reply

Using DTS to write from DB to Excel

  • October 3, 2002 at 1:51 pm

    #105203

    Hello All -

    I am trying to use DTS to write the results of a SQL query to an Excel spreadsheet. I have done that successfully. However, when I re-run the package, it appends to my spreadsheet. I need for it to overlay the existing spreadsheet.

    I am looking for a way to do this using the DTS GUI frontend because I know absolutley nothing about VB, ActiveX, etc.

    Thanks in advance for your help!

    pf

  • October 3, 2002 at 6:00 pm

    #437806

    Then you will need to do a query transaction instead of a transformation. Otherwise use a query to truncate the spreadsheet and just rewrite the data to it.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Viewing 2 posts - 1 through 1 (of 1 total)

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