How can I export different Access Report into same excel file?
Any suggestions are appreciated.
Thanks in advance.



rfan

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.