Maximum Excel size

  • Thread starter Thread starter \(a\)
  • Start date Start date
A

\(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
 
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,

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.
 
Back
Top