UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Output To Excel    
 
   
Richyg01
post May 29 2008, 08:11 AM
Post #1

UtterAccess Veteran
Posts: 410
From: Teesside, UK
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
Go to the top of the page
 
+
mike60smart
post May 29 2008, 08:25 AM
Post #2

UtterAccess VIP
Posts: 8,450
From: Dunbar,Scotland
Hi

This thread will help?



Link to Previous Thread

regards

mike
Go to the top of the page
 
+
Richyg01
post May 29 2008, 08:46 AM
Post #3

UtterAccess Veteran
Posts: 410
From: Teesside, UK
Erm.

I dont really know, seems very complicated to me, also it uses a PREFormatted excel file which I do not have!
Go to the top of the page
 
+
Richyg01
post May 29 2008, 09:05 AM
Post #4

UtterAccess Veteran
Posts: 410
From: Teesside, UK
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.
Go to the top of the page
 
+
« Next Oldest · Access Queries · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 19th May 2013 - 07:56 PM