Analyze in excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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 ...
 
Dennis said:
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
Click to expand...

The older Excels have a 64,000 line limit (255 columns) , It sounds
like you are somehow hitting that.

Newer version have extended that limit.
 
Back
Top