Dual Query into Excel spreadsheet question

  • Thread starter Thread starter joave
  • Start date Start date
J

joave

Hi:

I have two queries that yield the same 5 columns as a result, but because
of the structure, it is impossible to put the contents of both into one
query. I would like to combine the two queries and put the results into one
excel spreadsheet (with VBA if possible). Can you help please?

Thank you in advance,

Dave
 
Clarification - I want to put the results of both queries into the same
Excel spreadsheet.

Thank you.
 
Hi:

I have two queries that yield the same 5 columns as a result, but because
of the structure, it is impossible to put the contents of both into one
query. I would like to combine the two queries and put the results into one
excel spreadsheet (with VBA if possible). Can you help please?

Thank you in advance,

Dave
Click to expand...

Try a UNION query: you need to go to the SQL window to do it.

SELECT field, field, field, field, field FROM Query1
UNION ALL
SELECT field, field, field, field, field FROM Query2

The fieldnames need not be the same, but the number of fields and their
respective datatypes must match.
 
Back
Top