I know there are similar queries to this already in the forum, but I still can't find the answer to my specific query.
I want to be able to use a button in excel to run a query in access. This cannot be done via putting code into excel and running due to the fact that I have to do this several different times.
Does anyone know what VBA would be needed in order to run a query already written in Access?
Many thanks
I want to be able to use a button in excel to run a query in access. This cannot be done via putting code into excel and running due to the fact that I have to do this several different times.
Does anyone know what VBA would be needed in order to run a query already written in Access?
Many thanks