How do I export large query results?

[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.

 

[Jeff Boyce]

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

 

[Pieter Wijnen]

Don't choose csv?
Maybe it limits csv's to excel limits, as microsoft has decided that csv is
an "Excel" file?

Pieter

 

[Guest]

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?

 

[Jeff Boyce]

What happens when you export to "text"?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Pieter Wijnen]

You need to do it via file /export w/o the query open

Pieter