Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Inserting Lines or Copying lines with formulas but without data | Excel Discussion (Misc queries) | |||
Vertical Lines on the Lines on 2 Axes Chart | Charts and Charting in Excel | |||
How do I get two lines within a row? | Excel Discussion (Misc queries) | |||
Deleting unused lines between used lines? | Setting up and Configuration of Excel | |||
printing grid lines when grid lines is checked | Setting up and Configuration of Excel |