Export Access Query to Excel Workbook with multiple Worksheets 1

[Vanessa9er]

I have multiple Access queries that I want to export into one excel wookbook. I can use the TransferSpreadsheet command, but I can't designate what worksheet to dump the data. Right now all I can think of is making 10 workbooks with one worksheet each and then having another workbook that ties them all together by linking through excel. Does anyone have a better solution? Please enlighten me!

Thanks.

 

[ETID]

You would not need to export the data to excel, (too many steps)...

Create a live link to an Access query (that combines your data) from within excel,

From excel click Data>Get External Data>New Database Query>....the choose msaccess databases* from the list...follow the wizard from there (to select your mdb and query within)then return your data to excel.

You can opt to use the wizard or MsQuery at this point...
after your comfy with this...I would recommend the MsQuery option.


when data is returned,...you can right click in the data and select properties to refresh on open...fill formulas etc.