| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Refresh an Access Query using VBA code in Excel
I have linked data in an excel workbook from a tabel in an Access database
The table has been created from a Make tabel query in the same database. For the data in the Access table to be up to date I need to run the Access query. Can somone suggest a suitable VBA code for me to run in Excel that will connect to the Access database and run (refresh) the query. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Import query from access into excel via vba, but will not refresh | Excel Programming | |||
| Query Refresh code | Excel Programming | |||
| Link Access query to refresh an EXCEL file | New Users to Excel | |||
| Web Query Logins and Access Refresh | Excel Programming | |||
| Code to run an Access query from Excel | Excel Programming | |||
![Peter G[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
