Maximum Excel size

I have a text file that has about 200,000 lines of data that I am trying to
import into MS Excel. When I do, only 65,536 lines import and a message
appears "File not loaded completely."

Is there any way to have the file completely load? My pc has enough ram and
cpu power to handle it.

If there is no way to load the entire file, is there any other program that
could be recommended that would meet my needs. The file is a delimited file
that I need to looks at trends between the entries.

Thanks

Katherine
Sun Oct 26 23:50:19 CST 2003

That is an Excel limitation (as opposed to a system, eg CPU, limitation)
that you can't work around - I'd suggest using a database instead and
running queries. If you get stuck with the import or query generation,
there are plenty of MS Access newsgroups you could post questions to.

HTH,
Katherine

"(a)" <no@spam.com> wrote in message
news:l61nb.194442$pl3.128198@pd7tw3no...
> I have a text file that has about 200,000 lines of data that I am trying
to
> import into MS Excel. When I do, only 65,536 lines import and a message
> appears "File not loaded completely."
>
> Is there any way to have the file completely load? My pc has enough ram
and
> cpu power to handle it.
>
> If there is no way to load the entire file, is there any other program
that
> could be recommended that would meet my needs. The file is a delimited
file
> that I need to looks at trends between the entries.
>
> Thanks
>
>

Earl
Mon Oct 27 07:58:19 CST 2003

a,

If you need to keep all 200,000 rows, the only way in Excel is to split them
into separate sheets, which must be done as the file is read in. You'll
need a macro for that. Separate sheets is generally not a good solution,
even when the records fall into some kind of categories on which you might
separate them. Access may be a better platform anyway, depending on what
you wish to do with the data.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"(a)" <no@spam.com> wrote in message
news:l61nb.194442$pl3.128198@pd7tw3no...
> I have a text file that has about 200,000 lines of data that I am trying
to
> import into MS Excel. When I do, only 65,536 lines import and a message
> appears "File not loaded completely."
>
> Is there any way to have the file completely load? My pc has enough ram
and
> cpu power to handle it.
>
> If there is no way to load the entire file, is there any other program
that
> could be recommended that would meet my needs. The file is a delimited
file
> that I need to looks at trends between the entries.
>
> Thanks
>
>

Andy
Sun Nov 02 00:52:06 CST 2003

Agree with Earl.

Microsoft Excel is not designed for storing a huge amount of data other than
the database. You may try to fix this issue through migrate from Excel to
database.

Here is a KB talk about this:

XL2000: "File Not Loaded Completely" Error Message When Running Text Import
Wizard
http://support.microsoft.com/default.aspx?scid=kb;en-us;214015


"Earl Kiosterud" <nowhere@verizon.net> wrote in message
news:Oh0LjJJnDHA.744@tk2msftngp13.phx.gbl...
> a,
>
> If you need to keep all 200,000 rows, the only way in Excel is to split
them
> into separate sheets, which must be done as the file is read in. You'll
> need a macro for that. Separate sheets is generally not a good solution,
> even when the records fall into some kind of categories on which you might
> separate them. Access may be a better platform anyway, depending on what
> you wish to do with the data.
>
> --
> Earl Kiosterud
> mvpearl omitthisword at verizon period net
> -------------------------------------------
>
> "(a)" <no@spam.com> wrote in message
> news:l61nb.194442$pl3.128198@pd7tw3no...
> > I have a text file that has about 200,000 lines of data that I am trying
> to
> > import into MS Excel. When I do, only 65,536 lines import and a message
> > appears "File not loaded completely."
> >
> > Is there any way to have the file completely load? My pc has enough ram
> and
> > cpu power to handle it.
> >
> > If there is no way to load the entire file, is there any other program
> that
> > could be recommended that would meet my needs. The file is a delimited
> file
> > that I need to looks at trends between the entries.
> >
> > Thanks
> >
> >
>
>