|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
October 10th, 2008, 07:58 PM
posted to microsoft.public.access
|
|||
|
|||
Export multiple queries to a single Excel file
I have multiple cross-tab queries that I'd like to output to a single
Excel file into separate tabs. Is this a possibility? 
|
|
#2
October 10th, 2008, 08:59 PM
posted to microsoft.public.access
|
|||
|
|||
|
Export multiple queries to a single Excel file
Absolutely. Just use the TransferText method to export your data. Specify
the same Excel file and each query will get exported to a separate tab. You can do it in a macro or in VBA: DoCmd.TransferSpreadsheet acExport, 8, "Query1", "C:\MySpreadsheet", True, "" DoCmd.TransferSpreadsheet acExport, 8, "Query2", "C:\MySpreadsheet", True, "" DoCmd.TransferSpreadsheet acExport, 8, "Query3", "C:\MySpreadsheet", True, "" -- --Roger Carlson MS Access MVP Access Database Samples: www.rogersaccesslibrary.com Want answers to your Access questions in your Email? Free subscription: http://peach.ease.lsoft.com/scripts/...UBED1=ACCESS-L "kidkosmo" wrote in message ... I have multiple cross-tab queries that I'd like to output to a single Excel file into separate tabs. Is this a possibility?
|
|
#3
October 10th, 2008, 10:43 PM
posted to microsoft.public.access
|
|||
|
|||
|
Export multiple queries to a single Excel file
Uzytkownik "kidkosmo" napisal w wiadomosci ... I have multiple cross-tab queries that I'd like to output to a single Excel file into separate tabs. Is this a possibility?
|
|
#4
October 30th, 2008, 07:13 PM
posted to microsoft.public.access
|
|||
|
|||
|
Export multiple queries to a single Excel file
I am trying to do the same thing, but when I have multiple rows, it'll only
do the first one. I have 18 queries and I want them to dump their information into a single spreadsheet. So far it will only do the first one and not the others. "Roger Carlson" wrote: Absolutely. Just use the TransferText method to export your data. Specify the same Excel file and each query will get exported to a separate tab. You can do it in a macro or in VBA: DoCmd.TransferSpreadsheet acExport, 8, "Query1", "C:\MySpreadsheet", True, "" DoCmd.TransferSpreadsheet acExport, 8, "Query2", "C:\MySpreadsheet", True, "" DoCmd.TransferSpreadsheet acExport, 8, "Query3", "C:\MySpreadsheet", True, "" -- --Roger Carlson MS Access MVP Access Database Samples: www.rogersaccesslibrary.com Want answers to your Access questions in your Email? Free subscription: http://peach.ease.lsoft.com/scripts/...UBED1=ACCESS-L "kidkosmo" wrote in message ... I have multiple cross-tab queries that I'd like to output to a single Excel file into separate tabs. Is this a possibility?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
