need more than 65,000 lines

[Guest]

does anyone know if excel has an add on or if excel 07 will allow more than
65,000 lines. I have files that are 250,000 + lines. if not excel can you
recommend another program?
thanks

 

[David Biddulph]

2007 has 1048576 rows by 16384 columns.

 

[Guest]

Excel 07 has 1 million plus.

 

[Jon Peltier]

I know Excel 2007 has many more rows, but when you have that many rows or
even the 65K of Excel 97-2003, Excel is probably not the best choice for
warehousing the data. You could stick the data into a database (e.g.,
Access) and use Excel to extract just the data needed for a given analysis.

- Jon

 

[Guest]

To echo the others, Excel 2007 will handle that number of rows of data.

To repeate what Jon Peltier said: with that much data, you may well be
better off using something like Access to warehouse the data and then extract
what you need from it at any given time to perform operations with it in
Excel.

I've already had one client move to 2007 to get the added rows of data (he
had some files with close to 500,000 rows (2 columns only). The data import
and minor manipulation we did with it went very well. But when we went to
trying to graph sections of the imported data (in the equivalent of 8800 row
groups) - charting brought the system to its knees. Would have been much
better to just deal with each of the 8800 data item groups individually,
probably.

 

[Guest]

Jason,

As recommended by the previous posters Access or a similar product will do
the job nicely, if and only if the data is in a table format than caqn be
imported into the database.

If your file contains multiples lines per record or non structured data if
is more difficult and a data analysis program may be better.

There are a couple of programs out that tha do the text to columns process
nicely like datawatches monarch or prompt from pinnacle software.

It just depends on your requirments.

Good luck.

 

[Jon Peltier]

I was going to state that for many people, the added rows and columns will
seem like a great reason to upgrade. The other issues, however, beg
otherwise.

This related anecdote may shed a little light.

I've never used a lot of database resources, though in many projects I've
interacted with CSV files. A recent project had multiple MB files with 50k
rows, well within Excel 2003's limits, but they were slow to import or to
open in VB using my standard I/O techniques. I sat down with SQL for Dummies
and Google, and figured out how to deal with these files in ways that didn't
need 50k rows of my worksheet, and that ran in less than 1/10 the time. Now
I use SQL for the small files too: SQL lets me operate directly on the data
in the files, so I don't need to manipulate all these arrays in VBA.

- Jon