Microsoft.Jet.OLEDB.4.0 - Provider can not be found or it may not be installed Microsoft.Jet.OLEDB.4.0 - Provider can not be found or it may not be installed vba vba

Microsoft.Jet.OLEDB.4.0 - Provider can not be found or it may not be installed


The provider will fail like that on Window 7 Office x64 as the provider isn't supported on that platform.

You need to install the x64 Microsoft Access Database Engine 2010 Redistributable and change your connection string to Provider=Microsoft.ACE.OLEDB.12.0