| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code to run an Access query from Excel
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Query from Access into Excel cause Access to go to read only | Excel Discussion (Misc queries) | |||
| Can I use MS Query in Excel like an Append Query in Access | Excel Discussion (Misc queries) | |||
| Microsoft Query rejects "nz" function in Access Query | Excel Discussion (Misc queries) | |||
| How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) | |||
| Problem Code: Retrieving Stored Access 03 Query | Excel Discussion (Misc queries) | |||
Threaded Mode
