Microsoft Office 12.0 Access Database Engine Oledb provider in SSIS

Question

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?

Answer 1

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.