Fari,
One solution is to get the new version of Excel, which does not have the 65K
row limit.
Otherwise Google for "Excel import more than 65000 rows" and you will get a
lot of hits.

NickHK

"fari" wrote in message
oups.com...
Hi,

I have several text files having more than 65000 rows. The character
separating the rows is | (piped character). Can someone help me as to
how this can be done. Its all right if the data runs across several
sheets for each file.


I will really appreciate the help.


Warm regards


Fari