importing text files over 65000 lines???

[Larry]

Hi all,
I have a text file (access log's for a day) which is
about 103000 lines, I would like to import this into Excel
so that some sorting can be done, however when trying to
complete this using the import text file option, it tells
me that the file is to large to fit on one worksheet,
however that I can use the import wizard to contine on the
next sheet.

I have tried several times and I can not work out how.
Any one able to explain this to me, I am using Excel 2000
(9.0.4402 SR_1)

Thx
Larry

 

[Ron de Bruin]

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q120596
XL: Importing Text Files Larger Than ???? Rows

See this, maybe you can use this one

 

[Jim Rech]

This article describes the issues:

http://support.microsoft.com/default.aspx?scid=kb;en-us;119770&Product=xlw

I think I'd use a text editor to carve the text file into two files of 65K
or fewer lines.

 

[Guest]

Many thx, that did the job a treat, and now i might be
able to do something else this week,

Larry