See Mr Erlandsen's site for examples using ADO:

http://www.erlandsendata.no/english/vba/adodao/


http://support.microsoft.com/?kbid=295646
HOWTO: Transfer Data from ADO Data Source to Excel with ADO


http://support.microsoft.com/?kbid=246335
HOWTO: Transfer Data from an ADO Recordset to Excel with Automation




--
Regards,
Tom Ogilvy

"Kelly" wrote in message
...
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