Importing Large Databases

  • Thread starter Thread starter Bart Vwb
  • Start date Start date
Split into smaller pieces and use two worksheets?

(or wait for the next version of excel!)
 
Bart Vwb said:
::How can I easely import big databases (more than 70.000 lines) in
Excel ?undefined::
Click to expand...


In pieces..?

Why would you want to do that ? What things do you need to do that Access
for instance cannot do ?
Note: If you have seriously big excel-files and long and/or complex
calculations, it can look as if excel crashes. In my experience it does not,
but does take an awful long time to (finish and) react again.

Bas Hartkamp

 
Hi Bas,

Yep, in pieces -- or, as Dave advises, wait about a year. Ever try to get
Access to calculate a true median? It's possible, sure, but it's a lot more
tedious than entering this:

=MEDIAN(rng)

Or PMT() or MINVERSE() or LINEST() or any of roughly 300 functions that
Access doesn't offer. Don't get me wrong, I'm almost as big a fan of Access
as I am of Oracle or SQL Server as a way to store and retrieve data. But
they're just not there when it comes to analyzing that data.
 
Or, if you're VBA-savvy, use ADO or DAO to pull the data into a VBA array
and use the array instead of a worksheet range.
 
Back
Top