Code to run an Access query from Excel
Hi Group. I am using the Office 2000 package.
Some details.
I have created a query in Access and saved it. The query
collects columns of data from a few employee databases.
I need this data entered into a "control" sheet on a
template I have created.
Does anyone know if there is code that can be run from
excel that will go out to a local drive and run an Access
query, then take this data and save it to a specific range
in my control sheet?
Thanks,
Kelly
|