Export Record Limitations

A

Abby Dabby Doo

Access 2007 will not allow me to export a query with over 65,536 records to
Excel. (65,536 was the limit of rows in Excel 2003), but I have Excel 2007.

Does it matter that when Excel 2007 was installed it was set up to work in
compatability mode? Does it matter that the DB was created in Access 2003
but is being accessed by Access 2007?
 

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

What is the Excel 2007 rows limit for Excel 2003 macros? 0
How to export more than 65,536 lines from Access to Excel 17
Export Access table to Excel that has more than 65000 records 5
Compatability Mode 1
Export to XML - error 31532 0
Override Access's Current Internal Choices 4
Macro to export query to Excel 2
Exporting from Access 2003 & Access 2007 to Excel 1

Top