If you can get the file in a text/csv file format, you can split the import
across multiple sheets. See
www.cpearson.com/Excel/ImportBigFiles.aspx for
example code.
The 64K row limit in 2003 cannot be changed.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)
"Nainar" wrote in message
...
Hi am using Excel 2003.
I am in need to work / download data from SAP system into spreadsheet.
I need to download about 2 lac rows of data into excel. whereas Excel 2003
allows me upto 65 odd thousand rows only ... How can I download / view
this
one ??