Export multiple queries to multiple worksheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I found a post that explained how to export mutliple tables to one Excel
spreadsheet by using TransferSpreadsheet and ranges. Is there a way to
transfer different tables and/or queries to separate worksheets within the
same Excel workbook?
 
Yes. Although Access Help says identifying a range in an export will create
an error, at least in 2000 and 2003 it does actually work. A range can be a
sheet name.
 
Seems to be a very good idea to take some time to search the forums...

This worked perfectly, I would never thought about trying it...because help
file says it's only for importing

Thx
 
Back
Top