"Too Many Rows to Output" message

G

Guest

I ran a query with 42,000 records (rows) I'm trying to output to (analyze in)
Microsoft Excel 2000 running Windows XP. However, I get the following
message: "There are too many rows to output, based on the limitation
specified by the output format or by Microsoft Access". Is there a fix for
this? Can I change the limitation specified by the output format or by
Microsoft Access?
 
M

[MVP] S.Clark

65500 is the hard limit in Excel. So, I'm guessing you have many columns in
each row, which is why you're limited to a mere 42,000 instead.

Maybe summarize the data a little more before exporting.
 
V

Van T. Dinh

IIRC, both Office Link / Analyze It with Excel and the OutputTo method
default to an earlier version of Excel format (Excel 5???) that can only
take 16K rows.

Try using the Menu File / Export ... the TransferSpreadsheet mothod (in VBA)
where you can specify the Excel 2000 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

Output Query as an Excel file 2
Why no 'Export' functionality? 5
Too many rows to Output 4
Trouble exporting Report to Excel 1
Access and Excel 2007 - 65000 rows limitation trouble 4
Access Macros Too Many Rows to Output error message 1
Limitation of rows to output 4
too many rows to output 1

Top