Analyze in excel

[Dennis Fits]

MS-Access 2000.
I wrote a simple query to select a certain population of records.
When the data sheet is created, I attempt to send it to excel (55,000
Records) usig the Tools, Office Links, Analyze In Excel, and get this error
that it exceeds its limit either in Excel or MS Access.
Is there an option or limit of what I can sned to Excel from MS-Access?
Thanks,
D

 

[KARL DEWEY]

Excel has a row limit of 65K.
In SQL view add the your SQL statement like this --
SELECT TOP 65000 xxx.xx, xxx.yy, xxx.zz ...