You will need to change them according to your needs. It is saved at 'C:\Users\Manish Singh\Desktop' location. My database's name is ' Test Database.accdb'. To connect Excel to an Access database, you need to have an Access database. Write a VBA Code To Stablish a connection to the Access Database

Now we are ready to create a link to the Access Database.Ģ. Now look for Microsoft ActiveX Data Object Library. So first we need to add the reference to ADO object.Īdd a module to your VBA project and click on the tools. We will be using ADO to connect to access the database. So, let us learn how to connect the Access database as a data source to Excel through VBA.Ĭonnecting Access Database as Data Source Excel

But when we use Excel and Access together, the power of these tools increases exponentially. However, Excel can not store too much data. Where Excel is a powerful tool for crunching down data into meaningful information. The Access database is a relational database management system that effectively saves a large amount of data in an organized manner.