Huge file import is truncated

J

Jo

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
 
D

Dave Peterson

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.
 
J

Jo

Thanks Dave. Yes, 1M would be enough...for now. ;-) I'm not sure I want to
get involved with beta-testing though. Thanks for the suggestion. I may have
to bite the bullet and learn to use Access, although I'd prefer to see the
whole file at once. I can view the whole file in Wordpad, but I would like to
sort it using, for instance, the error code.

In any case, thanks for your reply. :)

Jo
 
M

MDubbelboer

you'll definitely have to import it into access or something of th
like

you can always break it up into ~65,000 file chunks and put into exce
as different worksheets but that would require splitting it in access
or some other program that can accept that many rows
 
J

Jo

Thanks MD. Yes, I could do that in Wordpad. It's a pain, but it is an option.
Thanks for the suggestion. :)

Jo
 
Top