Excel Import

P

PeterK

I have multiple queries that I would like to export into
one excel file. I would like each query to export into a
specific worksheet within the one excel file. Any
suggestions?

THX
 
E

elsa

Do these queries have the same fields? If they do then
you can create a UNION query to put all the data together,
even if the tables are not linked and then expost that to
Excel.
 
Top