Huge file import is truncated

[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

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



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

[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


"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
>

[MDubbelboer]

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.

sorry i misread your access comment. maybe try open office's equivalent, base. it's free, i've never personally used it so I have no feedback on it that way

[Jo]

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