August 17, 2001 at 1:19 am
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
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
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply