Released versions of Excel only have 65536 rows.

You may be able to join the beta testers for xl2007 (1 million rows), but I
don't know if that's enough, either.



Jo wrote:

I'm trying to import a text file (raw website stats log) that's in the
neighbourhood of 150MB. Excel 2003 truncates it after a mere 65,536 lines,
which is just a small fraction of the total lines in the file.

Is there any way I can pull the whole file into Excel? I'm running on Win-XP
with 1GB of RAM. Windows and programs are loaded on a 30.4GB partition of a
80GB harddrive. The memory (AFAICT) is system-managed (not manually input).

Any help with this is most appreciated, as I would like to be able to work
with these website stats files on a regular basis, and Excel would be great
and easy to use for this, if I can just get the whole file in there at once!
I don't have Access and am not in a position to purchase it at this point, so
it's going to have to be Excel for now.

Thanks.

Jo

--

Dave Peterson