R rfan New member Local time Today, 17:42 Joined Mar 13, 2007 Messages 9 Mar 13, 2007 #1 How can I export different Access Report into same excel file? Any suggestions are appreciated. Thanks in advance. rfan
How can I export different Access Report into same excel file? Any suggestions are appreciated. Thanks in advance. rfan
L llkhoutx Registered User. Local time Today, 16:42 Joined Feb 26, 2001 Messages 4,018 Mar 14, 2007 #2 Transfer the report recordsource, not the "report" itself. use docmd.transferspreadsheet acexport etc., picking the sheet and or cells you want to the data to go to.
Transfer the report recordsource, not the "report" itself. use docmd.transferspreadsheet acexport etc., picking the sheet and or cells you want to the data to go to.
