OLE DB Provider Microsoft.ACE.OLEDB.15.0 Mssing

Question

I deployed an SSIS package that retrieves data from a Microsoft Access database. it works fine locally and on the server I run it using DTESEX 32 bit, but I get the 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 the Microsoft.ACE.OLEDB.15.0 OLE DB provider exists on the server

Answer 1

Please try installing Access 2013 runtime on the server, which should allow the use of this provider (at least in the 32-bit version).

An exception indicates that it cannot find the specified OLE DB provider, which can be installed through standard Access installations or by installing the runtime.

Answer 2

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

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

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

Answer 3

@Gaurav Saneja, "SQL Server 2016 (64-)" ( ""). SSMS 32-, 32- DLL, , () 64- Office.

AccessRuntime_x86_en-us.exe https://www.microsoft.com/en-us/download/details.aspx?id=39358, :

32- Office, 64- : -list of installed Office apps here-

Microsoft 64- SSMS, , 64- ( ).

Answer 4

: (64- ) Windows 10 Pro (64- ) Visual Studio 2017 (32- ) Visual Studio 2017 (SSDT) (32- ) Office 2016 (64- )

Excel SSIS. : 2016 2013 . . 2016 :

HRESULT: 0xC020801C : OLE DB Microsoft.ACE.OLEDB.16.0 . 32- , 64- . : 0x00000000. OLE DB. : " Microsoft OLE DB". : 0x80040154 : " ".

[ Excel [2]]: SSIS DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. AcquireConnection " Excel" 0xC0209302. , AcquireConnection.

2013 :

HRESULT: 0xC020801C : OLE DB Microsoft.ACE.OLEDB.15.0 . 32- , 64- . : 0x00000000. OLE DB. : " Microsoft OLE DB". : 0x80040154 : " ".

[ Excel [2]]: SSIS DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. AcquireConnection " Excel" 0xC0209302. , AcquireConnection.

: : 64- Access Database Engine 2016 . , 2007 Data Access Engine 2016 : 2007 (32- ): Office 2007 https://www.microsoft.com/en-us/download/details.aspx?id=23734

2016 (USE 64bit): Microsoft Access Database Engine 2016 https://www.microsoft.com/en-us/download/details.aspx?id=54920 , Visual Studio 2017 (SSDT) , :

1. SSIS
5. Click Debug and change Run64BitRuntime to False
6. Click OK

Configure Connection Manager: 7. Open Excel Connection Manager. 8. Click the drop-down menu. Excel options work: Excel 97-2003 and Excel 2007-2010 9. Click Ok

Open the Excel Source component: 10. Select Excel Connection Manager. 11. Select "Table View" in data access mode. 12. Select Excel Sheet.

You must be able to preview the data in an Excel worksheet.