"Too Many Rows to Output" message

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.


--
Steve Clark, Access MVP
http://www.fmsinc.com/consulting
*FREE* Access Tips: http://www.fmsinc.com/free/tips.html


"cjlars" wrote in message
...
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?

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.

--
HTH
Van T. Dinh
MVP (Access)



"cjlars" wrote in message
...
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?