export multiple queries to excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 3 queries that I would like to export to the same excel spreed sheet
at the same time and in a specific order, is this possible using a macro? Any
help appreciated.

Thanks
Joseph
 
Joseph,

Do you mean to three separate worksheets within the same Excel workbook?
Or so you mean the data following each other on the same worksheet?
 
Steve,

Best case would be the data following each other on the same worksheet from
left to right.

Thanks

Joseph
 
Joseph,

Ok, first of all, go to the Excel worksheet, and select a range of cells
that will be the first row of the first imported query, so this will be
the same number of columns as the number of fields in the query. Then
give this range a name. Do the same for the place in the worksheet
where you want the second and third queries to be put. Then, in your
Access macro, use a TransferSpreadsheet action for each query, and enter
the name of the applicable range in the Range argument.
 
Back
Top