RAJU
RAJU

Reputation: 41

Microsoft Office 12.0 Access Database Engine Oledb provider in SSIS

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

Answers (2)

Apsara Karki
Apsara Karki

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

Johannes
Johannes

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

Related Questions