View Single Post
  #4   Report Post  
Timothy L
 
Posts: n/a
Default

Description of Excel 2000 specifications
http://support.microsoft.com/kb/264626/


Start another Worksheet and then import the remaining portion of your CSV file by using the Text Import
Wizard.

Please note: The instructions below are for Microsoft Excel 2003, but should work in Microsoft Excel 2000.


Insert a new worksheet
http://office.microsoft.com/en-us/as...008891033.aspx


Import a text file
http://office.microsoft.com/en-us/as...573861033.aspx

When you get to step 5, you should have the "Text Import Wizard - Step 1 of 3" dialog up. In Step 1 of the
Text Import Wizard, change the value next to "Start import at row" to 65537.



In addition, you might want to take a look at this program called CSVed. It is an easy and powerful CSV file
editor.
http://home.hccnet.nl/s.j.francke/t2t/text2table.htm

--
Please post all replies to the newsgroup for the benefit of others.
Requests for assistance by email will NOT be acknowledged!



"Larry Liu" <Larry wrote in message
...
I have a csv file that I try to import into Excel and the number of rows is
larger thatn 65536. The Excel 2000 seemed to be only capable of loading 65536
rows. Is there a way to overcome this ?