Access Can Not Export Large Table?

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

 

[Arvin Meyer [MVP]]

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

 

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

 

[Arvin Meyer [MVP]]

You can if you gave a sequential autonumber as a Primary Key.