|
-
Jun 22nd, 2018, 03:26 AM
#1
Thread Starter
Addicted Member
Re: Output several query results in same xls worksheet?
Not sure if there is a direct way to do this, but you can create temporary table with Jet SQL(Access SQL).
Create separate INSERT queries which will insert the data needed into this temporary table and then just one SELECT query with all data into an Excel file.
Then you can also drop your temporary table with VBA/JET SQL.
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|