Exporting Access Queries To Excel 1

[debzz]

Hello,

I currently have a Query that I'm exporting to excel programaticaly (sp?) via the OutPutTo command. It works fine.

I want to add two other queries to the same Excel file, but as separate worksheets (tabs) in the excel file. Currently when I attempt this, it overwrites the existing file.

So, I basicly have 3 Queries I'd like exported into one excel file, but with separate worksheets. I have a feeling OutPutTo is not going to work for me.

Access Version is 97 Currently. But that can be changed to Access 2000 if needed.

Thanks,

Deb

 

[jebry]

Hi Deb!

Use the DoCmd.TransferSpreadsheet instead. This will add sheets to an existing workbook or create the workbook depending on whether or not the workbook exists. You may need to put a message box between each export just to give the query time to run before starting the next.

hth


Jeff Bridgham
Purdue University
Graduate School
Data Analyst

 

[debzz]

Thank You!!! That worked like a charm