Export over 65k records to Excel

[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

 

[Guest]

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.

 

[Joseph Meehan]

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

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