Maximum Number of Records in Excel WorkSheet

Posted by Michael on July 16, 2001 8:41 AM

Can any one can help , please :

I have 106000 records in text format (or in Paradox format) but I cannot import to Excel those 106000 records, only around 16000 records are imported. How can I increase memory in Excel or what should I do to import 106000 records (rows) in one worksheet.

Thanks in advance.

Posted by Damon Ostrander on July 16, 2001 8:53 AM

Michael,

There is no way around the 2^16 row per worksheet limit in Excel. However...

If you import the data using VBA I/O statements (e.g., Open, Input #, Line Input #, etc.) instead of Excel Open (or Open Method) then you gain control of the process so that you can automatically wrap the data to additional worksheets.

Damon

Posted by Mark W. on July 16, 2001 9:01 AM

Macro to do as Damon suggested...

http://support.microsoft.com/support/kb/articles/Q120/5/96.ASP