Maximum Excel size

[\(a\)]

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

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

 

[Earl Kiosterud]

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.

 

[Andy Chang]

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