Export several queries to one excel sheet 2

[karjoe]

Hi,
I do know how to export a query to excel, Is there a way to export several queries to one excel sheet in Access 2007?

Thanks in advance

 

[dhookom]

Are the columns the same in all queries? If so you might be able to create a union query. You can always use automation but it is more complex.

Duane
Hook'D on Access
MS Access MVP

 

[rekrabnai]

Just to clarify. Do you require an excel file with more than one worksheet in it (1 for each query) or an excel file with a single worksheet (all query results in a single sheet)?

Sometimes if you want to put a nail in a piece of wood, you just gotta hit it with a hammer!!

 

[karjoe]

Hi,
Answer to hookom question: 3 queries generate one column that shows count. All the other queries have the same columns.

Answer to rekrabnai question: Looking for an excel file with a single worksheet (all query results in a single sheet)

Thank you

 

[dhookom]

You could try the union query or automation.

Duane
Hook'D on Access
MS Access MVP

 

[karjoe]

Yes. I am try a union query.
Thanks for all your help