export to excel with a twist ?

[Set up of Outlook]

Hello all,

I am using Access 2003. I have a quarry that runs to give me totals of job
codes done for specific tech's and I want it to export to excel but is there
a way to get access to make a new worksheet for each tech during the export?
Or baring that any thoughts??

Thanks

 

[Klatuu]

No, TransferSpreadsheet is not that intelligent. There are a couple of ways
to do this. If you have any experience at all in communicating with Excel
via code, then you could write code that would create the workbook, create a
worksheet for each tech, use a parameter query to create a recordset for each
tech, and use the CopyFromRecordset method to put the tech's data in the
correct sheet.
The other way would also involve using a parameter query to limit to a
specific tech, and use the TransferSpreadsheet method to export the data.
You would have to create a control loop that would call the query for each
tech.