I need to create a vbscript in a DTS pkg that takes the results of a query
and exports the data to a spreadsheet but exports data on different sheets
with in the workbook according a group.

In short I want to group the data then export it to a different sheet with
in the same workbook.

Any help with this would be greatly appreciated.

Thanks,

-Chris

I have written to different Excel worksheets using ADO. Create a named
range in each sheet. These names are global to the workbook. Connect
the workbook and the range (sorry I don't have an example handy).
Caution - even if you tell it that you are not writing a row of names,
it still skips a row before the data gets written.
Yoy may have to use CreateObject and set a reference to the ADO
library.

Hope this helps,
IanO

Thanks for you help. I will give it a try

ca

"IanO" wrote: