Access Can Not Export Large Table?

  • Thread starter Thread starter Al Franz
  • Start date Start date
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.
 
You may have to break it into numerous smaller queries and export them 1 at
a time.
 
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Export large query from Access 3
TransferText using wrong format 0
Export to csv 6
Access 2003 db's & problems exporting query to Excel 1
Exporting Access Table to text file 9
export xml - slow Access 2007 5
Export query to Excel fails 6
Rounding difference in Access 2003 text exports 2

Back
Top