Access Can Not Export Large Table?

A

Al Franz

Ran a query that produced a huge result, 45 million records. I can not seem
to find a way to export it. Have tried TEXT File Export with no Formatting
which has worked for other large outputs, though nothing this big. And it
still fails with an error code -1. Is there no way to export this result
from Access. I want to get it into a CSV file somehow.
 
A

Arvin Meyer [MVP]

You may have to break it into numerous smaller queries and export them 1 at
a time.
 
A

Albert

What is the best way to do something like this? Can you return only
records 1-1,000,000; and then the 2nd million in a 2nd query?
 
Top