We know that we can run query from excel vba either using DAO or ADODB connection to MS Access. I wanted to know how to run the vba from excel to retrieve and update MS Access tables but the system is not installed with MS Access. What is the way to connect an MS Access file without having it...
