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

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
Is there a way for you to specify which records in a query, then export
that?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
do you mean that i would actually do the export from my query command? If so,
what is that command?
 
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
 
Back
Top