importing text files over 65000 lines???

  • Thread starter Thread starter Larry
  • Start date Start date
L

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
 
Many thx, that did the job a treat, and now i might be
able to do something else this week,

Larry
 
Back
Top