Hi
I have a Access DB which contains four tables that are linked to excel sheets. I also have a query. I would like to start Access from VBA in Excel, and launch the query form there. Unfortunately I cannot run the query using Docmd.RunSql because this is a “SELECT” query. I was thinking about starting Access form Excel VBA and using the Refresh method for my DB. Ultimately I want the refreshed data loaded into Excel worksheet. I’d like to ask If the refresh method would update the data in the linked tables and the query? If not, I would appreciate any suggestions on this problem. Thanks in advance
I have a Access DB which contains four tables that are linked to excel sheets. I also have a query. I would like to start Access from VBA in Excel, and launch the query form there. Unfortunately I cannot run the query using Docmd.RunSql because this is a “SELECT” query. I was thinking about starting Access form Excel VBA and using the Refresh method for my DB. Ultimately I want the refreshed data loaded into Excel worksheet. I’d like to ask If the refresh method would update the data in the linked tables and the query? If not, I would appreciate any suggestions on this problem. Thanks in advance