I am learning VBA to integrate an Excel macro that will connect to the Northwind.mdb database in Access 2003 and then run its query eg. Current Product List. Is this possible? If so how?
Thanks for any help
Pete
Asked
Active
Viewed 184 times
0
-
1Have you looked into the `Excel Menu` --> `Data` --> `Get External Data` --> `From Access`? – Ralph Jun 30 '16 at 20:22
-
I don't want to get I need to run the query in access? The excel macro should call it? – ChrisR Jun 30 '16 at 22:55
-
I see. In this case the question is a duplicate of the following and should be closed: http://stackoverflow.com/questions/24437642/running-an-access-query-from-excel – Ralph Jun 30 '16 at 23:05