Reputation: 41
I am not able to see Microsoft Office 12.0 Access Database Engine Oledb provider in SSIS and I'm using MS Office 2013.
How to re-solve this?
Upvotes: 4
Views: 35420
Reputation: 1
I also had same issue. I could not find Microsoft Office 12.0 Access Database Engine oledb even after installing Microsoft Access Database Engine 2016. Then I installed both versions: Microsoft Access Database Engine 2010 and Microsoft Access Database Engine 2016, now the issue is resolved.
Upvotes: 0
Reputation: 404
You are missing the Microsoft Access Database Engine 2010.
Download it here: https://www.microsoft.com/en-US/download/details.aspx?id=13255
Install it on your dev-client and on your servers. After the installation has completed, you should see the Microsoft Office 12.0 Access Database Engine OLEDB provider in your Visual Studio's connection wizard.
Upvotes: 11