Export To Excel

  • Thread starter Thread starter LJG
  • Start date Start date
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
 
You will need to automate Excel to have this level of control over it. Have
a look at OLE Automation
 
Back
Top