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
|
|||
|
|||
NUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUL
De: "Sara" Objet: Export multiple queries to a single Excel file Date: jeudi 30 octobre 2008 20:13 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? |
#2
|
|||
|
|||
NUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUL
"hyututr" wrote in message ... De: "Sara" Objet: Export multiple queries to a single Excel file Date: jeudi 30 octobre 2008 20:13 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 | |
|
|