How to connect Excel to access database using VBA?

Add a module to your VBA project and click on the tools. Here click on the references. Now look for Microsoft ActiveX Data Object Library. Check the latest version you have. I have 6.1. Click OK button and it is done. Now we are ready to create a link to the Access Database.
For More Information Please Refer:

You May Also Like to Read: