Post reply

DTS to excel

  • August 17, 2001 at 1:19 am

    #157508

    Does anyone know how to automaticaly export tables (or different sql-selection) to a different spreadsheets in the same excelfile?

    I tried with DTS and from a store procedure to call the DTS via OLE object and send the tables name and execute the package.But I didn't work it out how to save data into different spreadsheets and how to dynamically build the connection(destination columns) into excel.

    Any suggetions?

    Thanks in advance!

    Sica

  • August 25, 2001 at 8:37 pm

    #417797

    Hi Sica,

    Sorry for not replying to you sooner - things get busy on here sometimes! I know with Excel 97 there was a "feature" where if you tried to export to a file with the same name, it would actually add a sheet to the workbook. Kinda handy. Worth a try.

    If that doesnt work, your best bet would be to create the sheets as separate workbooks, then use Excel automation to consolidate into one book.

    Andy

    Andy
    SQLAndy - My Blog!
    Connect with me on LinkedIn
    Follow me on Twitter

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

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