View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kelly[_7_] Kelly[_7_] is offline
external usenet poster
 
Posts: 10
Default 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