Exporting a query > 65K records

A

AmandaM

Hi -

I'm pretty new to macro's. I need to export the results of a query to an
excel sheet but on occasion the results are greater than 65000 records. How
do I get the macro to complete the export on the second sheet of the workbook
in those instances?

I did see some other posts regarding exporting to multiple sheets, but they
were a little over my head.

Any help is appreciated.
 

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 separate query results to same workbook diff worksheets 2
Limit record count in query 1
Exporting Query - Want count of records 5
Split query to export to Excel 6
Odd Export as PDF problem - Killing me. 6
How do you Export Data from Access into Multiple Tabs in Excel from one query 8
Locate Specific Records from Queries and Export to Excel 2
Problem with ExportAsFixedFormat with selected sheets 0

Top