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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel In Excel how can I save a value on daily basis 2
Create flexible Query - One instead of dozens 6
Convert Date from yyyymmdd format to numeric day of week (1=M, 2=T 4
Multiple IIF Statement... 4
How to reference all dates to a "Monday" 4
Export to Excel 1
How to write a query that add 1 working day to the date 2
Export Query to Text without delimiters 4

Top