Full Version: Output To Excel
UtterAccess Discussion Forums > Microsoft® Access > Access Queries
Richyg01
Hi

I am wanting to output a number of queries to a single excel document (system created)
I would like to result of each query to be on a seperate worksheet.

Is any of this possible??

Thankyou
mike60smart
Hi

This thread will help?



Link to Previous Thread

regards

mike
Richyg01
Erm.

I dont really know, seems very complicated to me, also it uses a PREFormatted excel file which I do not have!
Richyg01
I have found a way that you can export the 3 queries, one after the other using Transfer Spreadsheet.

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "qryOne", "C:\...MyFile.xls"

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "qryTwo", "C:\...MyFile.xls"

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "qryThree", "C:\...MyFile.xls"

The above will give you 3 tabs in the same workbook.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.