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

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

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


"Dave Peterson" wrote:

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

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

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


--
MDubbelboer
------------------------------------------------------------------------
MDubbelboer's Profile: http://www.excelforum.com/member.php...o&userid=36330
View this thread: http://www.excelforum.com/showthread...hreadid=562931

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

Jo


"MDubbelboer" wrote:


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

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


--
MDubbelboer
------------------------------------------------------------------------
MDubbelboer's Profile: http://www.excelforum.com/member.php...o&userid=36330
View this thread: http://www.excelforum.com/showthread...hreadid=562931