Export To Excel

L

LJG

Anyone any clues if this can/ if this works?

I have an access query that I want to export to a spreadsheet, Each record
relates to a day of the week, i.e. Monday, Tuesday etc.

For each day I want to add a new worksheet and add the data for that day to
the sheet

any ideas ?

Thanks
Les
 
J

JohnFol

You will need to automate Excel to have this level of control over it. Have
a look at OLE Automation
 
Top