Does Excel 2000/2003 have a max number of records like '98 has?

[Guest]

I'm trying to import data from Crystal reports to Excel then to Access. The
Crystal report has over 85000 records but Excel only allows 65585ish records
on sheet 1 and the rest on sheet 2. Would I have the same problem with
2000/2003?

Any ideas how I can make this work with Office ‘98?

 

[Harald Staff]

Yes, the limitation is the same in those versions. It changes in Excel 2007.

HTH. Best wishes Harald

 

[Guest]

export it as a csv file then open/import it in access