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