OLE DB provider Microsoft.ACE.OLEDB.15.0 Mssing

Question

I have deployed SSIS package that fetch data from Microsoft Access database. it works fine Locally and on Server i am running it using DTESEX 32 bit but getting following error

The requested OLE DB provider Microsoft.ACE.OLEDB.15.0 is not registered. If the 32-bit driver is not installed, run the package in 64-bit mode. Error code: 0x00000000.

How can i make sure that OLE DB provider Microsoft.ACE.OLEDB.15.0 exist on server

Answer 1

I tried importing data from 64bit excel file into SQL using SSMS's import wizard and got got this error :microsoft ace oledb 15.0 provider is not registered on the local machine.

One of my colleagues showed me to use 64bit import wizard rather than 32 bit defualt import wizard that I have in SSMS. Here is a short video I posted about successfully loading the data on youtube

https://www.youtube.com/watch?v=aIs-vbaGSzg

Answer 2

Per @Gaurav Saneja's answer, you can use the "SQL Server 2016 Import and Export Data (64-bit)" (found in start menu). SSMS is 32-bit, so it attempts to load the 32-bit version of the DLL, but fails because you (likely) have the 64 bit version of Office installed.

Some people are recommending the installation of AccessRuntime_x86_en-us.exe from https://www.microsoft.com/en-us/download/details.aspx?id=39358 however, for me this fails with the error:

We can't install the 32-bit version of Office because we found the following 64-bit programs on your PC: -list of installed Office apps here-

Until Microsoft provides a 64-bit version of SSMS, we are stuck using the method of launching the 64-bit version of the Data Import wizard independently (as described above).