Linking Excel to a Access database

[martin ridley]

I have created a query that is retrieving data from an Oracle database.
Unfortunately I am now retrieving more than 65,000 lines of data and th
worksheet can't handle the growth in data. I could break the query int
several parts to reduce the number of lines retrieved to each worksheet
but I think this problem will keep occurring with the growth in th
data.

We are using excel macros to count information in the data retrieved.
My boss wants the data in Excel to create graphs etc.

Is it possible to retrieve the data into Access and then use th
existing functions to count the data without having to shift the dat
into Excel again?

Thanks

Marti

 

[Frank Kabel]

Hi
maybe using a pivot table whcih access your databse could be a solution

 

[cradovsky]

In terms of summary options and reporting, Access can be more powerfu
in some areas than Excel, less so than others. Excel has mor
statistical operators, but Access has the basics.

Access can also pull in Excel-generated graphs, feed graphs data, an
has plug-ins for graphing.

One model might be to read the data via Access and perform some of th
brute summarization (e.g., collapsing by group variables, etc.). Thi
"middle" version of the data could then be accessed by Exce
dynamically for the final graphing/presentation.

In short, the best solution depends on the type of summary function
and graphing you are doing.

Regards,

Carlo