Export multiple queries to multiple worksheets

L

Lmanns

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?
 
K

Klatuu

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.
 
Z

Zurn

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
 
Top