Export over 65k records to Excel

  • Thread starter Thread starter Dan
  • Start date Start date
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
 
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.
 
Dan said:
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
Click to expand...

Wait for the next version of Excel?? It eliminates that limit.
 
Back
Top