Exporting to Excel

G

Guest

I am trying to export the results of a query in Access 97
to a table in Excel. When I try to run the export I get
the following error - "There are too many rows to output,
based on the limitation specified by the output format or
by microsoft access." I thought Excel's limitation was
around 65,000 records. Our output right now is a little
over 18,000 and the same exact process worked as little as
a week ago. Any idea what might've happened?
 
D

djh

Excel 97's limitation is 65536 rows per spreadsheet.
Make sure you are selecting this version of Excel in the
Save As Type specification below the filename. There are
older versions listed before it.
 
J

John Nurick

Some of the ways of exporting to Excel use the old Excel 7.0/95 file
format, which has a limit of 16384 rows.

To get more, you need to use File|Export (without checking "Save
Formatted") or DoCmd.TransferSpreadsheet and specify Excel 97 or later
format.
 

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 maximum number of rows when exporting query to excel 3
How do you change the Access exporting output limitation? 2
Exporting Access query to Excel 1
"too many rows to output" exporting query to Excel 2
Exporting to Excel 2007 1
Access export to Excel stops at about 45,000 not 65,000 XL limit 11
Trouble exporting Report to Excel 1
Macro to export query to Excel 2

Top