How do I export large query results?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello I need to export query results to a txt file. There are over 800,00
lines in the result. When I try to export it, it only exports the excel
limit of a little over 65,000 lines. How can I export such large data?
Thank you for your help.
 
You don't mention which version of Excel. As I recall, the newest version
can have many more rows than 65K.

You don't have to export to Excel. You could export to a text-delimited
format (e.g., comma-separated).

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Don't choose csv?
Maybe it limits csv's to excel limits, as microsoft has decided that csv is
an "Excel" file?

Pieter
 
It's the 97 version. I have the query results and it doesn't give me the
option to do text-delimited. I just went to file export and chose a text
file. Am I missing a step in there?
 
What happens when you export to "text"?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top