How do you export more than the maximum number of Records to CSV

G

Guest

I have an Access Table that has upwards of 1 million records. i don't want to
show them all at one time so my "Max Number of Records" is 10,000.
Unfortunately when i try to export the file to CSV, only the 10,000 records
that are showing get exported.
 
J

Jeff Boyce

Is there a way for you to specify which records in a query, then export
that?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
G

Guest

do you mean that i would actually do the export from my query command? If so,
what is that command?
 
J

Jeff Boyce

I really don't have an idea what you mean by "query command". What I was
asking about was whether your underlying data has some form of ID or
sequence number, something you could use as a selection criterion in your
query to identify/select certain groups of rows for export.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 

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 data from current record to csv 4
Formatting numbers in Text Export 4
Export To Excel with more than 65,000 records 3
Export Table as a csv file 1
Exporting calendar in csv file 2
the best way to export 600K records 2
Need to Export Data From Access into SAGE BusinessWorks Acct. Syst 8
Export to CSV file 1

Top