Automatr Access to Excel

R

Richard

I have (4) four access databases and run a query from each
one and past them into Excel to do calculations.

What I would like to do is automate the process so that I
open only the Excel file and the data from the (4) queries
appears in the Excel file after some time.

As I am more familiar with Excel than Access what I need
to know is:
How do I automate the process?
a) Running the (4) four queries in the (4) databases
and ending up in (1) Access database with the query
results in (1) one table.
b) I will the get the data from the single Access
via OBDC Query in Excel.
c) How can the process be started from Excel, or can
it?

Hopefully someone can help.

Thanks.
 
Top