Importing Large Databases

[Bart Vwb]

::How can I easely import big databases (more than 70.000 lines) i
Excel ?undefined:

 

[Dave Peterson]

Split into smaller pieces and use two worksheets?

(or wait for the next version of excel!)

 

[HS Hartkamp]

::How can I easely import big databases (more than 70.000 lines) in
Excel ?undefined::

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

 

[Conrad Carlberg]

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.

 

[Conrad Carlberg]

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.