"Too Many Rows to Output" message

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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.
 
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 output by query 5
Too many rows to Output 4
Trouble exporting Report to Excel 1
Access Macros Too Many Rows to Output error message 1
Access and Excel 2007 - 65000 rows limitation trouble 4
Problem with query output 1

Back
Top