Export over 65k records to Excel

D

Dan

Hello,
I need to export a query out of Access into Excel, but the query has more
than 65,000 records. Is there an easy way to export the data to Excel and
tell Access to create multiple sheets of data? I can always export the
query to a text file and copy/paste several times, but I would rather avoid
that if possible.

Thanks in advance,
Dan
 
K

KARL DEWEY

Maybe not what you are looking for but you can use a query to select TOP
64999 for export then update a flag field for the same 64999.

Next query has criteria to eliminate those flagged.
 

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

VBA - exporting serial letters to single documents 0
Embed the same Excel multiple times 0
Export to Excel 3
Export to Excel more than 900,000 records 2
Exporting Access query to Excel file with passwords 6
2007 Data Export Limit 2
Export to Excel from a report (getting wrong record) 0
Exporting Query from Access 2007 to Excel 2007 4

Top