Export multiple queries to multiple worksheets

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

Guest

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

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Exporting Data to One Excel Workbook to Several Worksheets 2
Exporting to Excel 2
Export multiple queries to multiple Sheets in Excel 1
How do you Export Data from Access into Multiple Tabs in Excel from one query 8
Exporting multiple queries into Excel workbook tabs 10
Access to Excel-Multiple tabs 1
Counting multiple memberships 1
Exporting pivot tables to excel 1

Top