Export Data from Data Access Page to Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My Data Access Page contains over 100,000 records and when I export to Excel
I only get the standard 65, 536 rows and I lose the rest of the data. Is
there any way of forcing the export to move onto the second sheet of Excel at
all so that all the data is exported correctly?
 
65, 536 is the limit of what Excel can accept. There is nothing you can do
to increase that. You would need to write a second query to pickup where
the first one left off and continue the export to a second sheet.
 

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

2007 Data Export Limit 2
Rounding difference in Access 2003 text exports 2
Exporting a table from Access 2003 to Excel 2007 1
Exporting Data from access and appending to an existing excel sprd 3
Exporting Query from Access 2007 to Excel 2007 4
export access data to excel 5
Link Access to Excel export back to excel 3
Export to Excel 3

Back
Top