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.

Odont 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.
oCmd.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 work
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.