Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run Access Action Queries from Excel?
I've done this before, but I can't find any of my old examples for
reference. I would like to execute an action query in Access from Excel using a VBA macro 1. The Excel spreadsheet has a range defined as a linked table into the Access app. 2. And there are two append queries in Access that will append data from the linked range periodically to a physical table in Access. 2. And, what I would like to so is, from within Excel, without having Access up and running, connect to the database, execute the query, and close the database as needed. What might be a good way to approach? Thanks in advance. Larry. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Access Queries not seen in Excel | Excel Discussion (Misc queries) | |||
Access Queries into Excel | Excel Worksheet Functions | |||
Queries from Excel 2003 to Access | Excel Discussion (Misc queries) | |||
Using Excel Worksheets like Access Queries | Links and Linking in Excel | |||
Running Access queries from Excel | Excel Programming |