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