Limited Export to Excel

  • Thread starter Thread starter Ian
  • Start date Start date
I

Ian

I do regular exports to excel of some queries but for some
reason it will only export 16,384 records(this is the
first time I've ever taken note of the number but I've had
a similiar problem before). I use Office 2003 but export
in Excel 97-2003. I've got just over 22,000 records in
the queery but it only exports up to the above number. If
I export in .tdf no problem. Anybody know about the glich
or a fix for it?
 
I'm pretty sure that is as many records as Excel will allow. You might
check the Excel help files.

Rick B
 
Excel can go over 60k
-----Original Message-----
I'm pretty sure that is as many records as Excel will allow. You might
check the Excel help files.

Rick B





.
Click to expand...
 
You must log in or register to reply here.

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

How to Export Gmail Emails to PST Format? 4
2007 Data Export Limit 2
Export to Excel - combine multiple fields in one cell 1
Error exporting data from access 2007 to excel 2007 1
Exporting a table from Access 2003 to Excel 2007 1
Exporting to Excel from Access 3
Exporting Access query to Excel file with passwords 6
Export to Excel + execute multiple query 1

Back
Top