Export table to excel and name tab.

[hwkranger]

I want to export a query daily to an excel worksheet.

I would like to append the worksheet, or create a new tab daily, although it would create alot of tabs. (other suggestions are welcome)

I want this to be an automated action, I currently have a form that builds the query, all i need is help with is the export.

Thankyou in advance. Cruz'n and Booz'n always.
This post shows what little I do at work.

 

[scking]

Actually all you need is to use Excel automation. Merely exporting data from Access WILL NOT a) append to an existing file, b) create named sheets, c) append sheets to a workbook. If you are ready to go this route let me know.

-------------------------------------
scking@arinc.com
Try to resolve problems independently
Then seek help among peers or experts
But TEST recommended solutions
-------------------------------------

 

[hwkranger]

Well, That answers my question as to why I can't figure out how to do that - i thought it was possible, but now I know it's not. I'm open to all your suggestions. Cruz'n and Booz'n always.
This post shows what little I do at work.