Export/Output Data In Table To Excel Limitations

G

Guest

I've been trying export and output data in a tables that contains about an
average of 45,000 records which is below the 65,000 rows that Excel can store
in each worksheet. I keep getting an message when doing this export/output
"There are too many rows to output, based on the limitation specified by the
output format or by (my database name). I using Access 2000 and Excel 2000
with a XP platform. Any idea of what I can do to get this to work.
 
J

John Spencer

What method are you using to export? Are you using TransferSpreadsheet? If
so, did you specify the spreadsheet Type or did you use the default for
spreadsheet type? The default is Excel 3 (which if I recall correctly has a
limit of 16,000 rows).

If you didn't use transfer spreadsheet, what method are you using.
SendObject uses an older version of Excel also, so that could be the
problem.
 

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

Access export to Excel stops at about 45,000 not 65,000 XL limit 11
OutputTo action 1
Limitation of rows to output 4
Best method / software for graphical output from dynamic excel data 0
Exporting from access to excel problem using vba. 1
Export to excel 3
Output Query as an Excel file 2
Why no 'Export' functionality? 5

Top