Access Queries into Excel

[TKM]

Can you export a seprate query into the same workbook in Excel? I have three
seprate queries that make up a report. I would like the first query (main
portion) to show first, The second and third query to export into tab number
2 and 3. Is this possible? Once I get the formatting etc down then I hope to
automate it if it's possible?

 

[Dave F]

You can run individual Access queries in Excel by using the External Data
Tool under the data menu. Essentially, if you use this tool, you need to
navigate to the folder where your Access db resides, find the Access object
in question (i.e., the query) and run it. If you record a macro while going
through all of these steps you can assign that macro to a button. So long as
the file paths from XL to MDB do not change, clicking the macro will
automatically run the query and populate an excle worksheet.

Dave