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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Export table to txt file with a variable filename 0
Exporting Multiple Queries to the same Excel File 4
Exporting Access Information into Multiple Excel Tabs Using a Macr 2
Problem creating export spec - "too few parameters" 1
Macro Exports to Excel 2
Access Access Select Query is cleared out after exporting 5
Exporting from Access to multiple sheets in excel 0
Access Macro to export table to Excel then run Excel macro 1

Back
Top