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

2007 has 1048576 rows by 16384 columns.
--
David Biddulph

"jason2444" wrote in message
...
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

Excel 07 has 1 million plus.
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"jason2444" wrote:

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

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"jason2444" wrote in message
...
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

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.

"jason2444" wrote:

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

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"JLatham" <HelpFrom @ Jlathamsite.com.(removethis) wrote in message
...
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.

"jason2444" wrote:

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

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.
--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"jason2444" wrote:

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