Is Excel enough power for 80.000 cells? Should I use Access to?

  • Thread starter Thread starter baldomero
  • Start date Start date
B

baldomero

Hello, I have to do an application to handle 14 columns (date and 13
integer variables) and rows to cover day by day through 15 years. That
is 14*365*15 cells.

I must do searches and comparisons between cells, and some mathematical
calculations (those ones won't be through all cells, but just between
some 10 or 20 selected cells).

The question is, should I use Access too to handle this information, or
is Excel enough powerfull to work with that alone? I prefer working with
Excel alone, but if it is needed, then the application will be made
based on both.
 
Baldomero,

You'll need less than 6000 rows to accomplish this. Not a problem with
Excel. The choice has little to do with capacity, but more with what you
want to do. For calculations, Excel excels. For storing in tables,
especially multiple tables (which you don't seem to need), handling records,
input forms, output screens and printed reports, Access is better. So on
the surface, anyway, with what you've said about what you need to
accomplish, Excel is the choice.
 
Well, then I'll try with Excel alone. I'll comment on that when I
implement the application to you guys. Thanks!!
 
Back
Top