Can not longer use import and Export Wizard to import Excel version 2016 after upgrade to Office 365. Error - "..OLE DB provider Microsfoft.ACE.OLEDB. 16.0 is not registered..."

Question

Can not longer use import and Export Wizard to import Excel version 2016 after upgrade to Office 365. Error - "..OLE DB provider Microsfoft.ACE.OLEDB. 16.0 is not registered..."

Pat Mesop 1

We recently upgraded from Microsoft Office 2016 to Office 365. We use SQL Server 2012 and in the process of importing data from Excel 2016 into
database tables, I find that I can no longer use the Import and Export Wizard to import data from Excel 2016 into SQL Server database tables. When I attempt to do so I receive the error,

'The requested OLE DB provider Microsoft.ACE.OLEDB. 16.0 is not registered. If the 32-bit driver is not installed, run the package in 64-bit mode. Error code: 0x00000000. An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered". Package1.dtsx 0"

It was working fine before the upgrade to Office 365. Obviously the upgrade replaced OLE DB provider Microsoft.ACE.OLEDB. 16.0 with the equivalence for Office 365 and there is obviously no backwards compatibility. Not sure what to do as I have a lot of Excel 2016 files data to import. Is there a configuration change that can make this work. What do I have to do to import older version of Excel in my Office 365 system using import and export Wizard.

Ceasar Chen_MSFT 4,481 Reputation points

2022-06-16T02:58:34.47+00:00

Hi,
Your question is related to SQL Server, and I added the tag of sql- server- general. It is recommended that you wait for a reply from a SQL Server expert.
ZoeHui-MSFT 41,491 Reputation points

2022-06-16T05:27:20.93+00:00

Hi @Ceasar Chen_MSFT ,

As mentioned that upgraded from Microsoft Office 2016 to Office 365. Please help check if it is the compatibility issue for Office 365.

1 answer

Your answer

Ceasar Chen_MSFT 4,481 Reputation points

2022-06-16T02:58:34.47+00:00

Hi,
Your question is related to SQL Server, and I added the tag of sql- server- general. It is recommended that you wait for a reply from a SQL Server expert.
ZoeHui-MSFT 41,491 Reputation points

2022-06-16T05:27:20.93+00:00

Hi @Ceasar Chen_MSFT ,

As mentioned that upgraded from Microsoft Office 2016 to Office 365. Please help check if it is the compatibility issue for Office 365.

Answer 1

CathyJi-MSFT 22,396 Microsoft External Staff

Hi @Pat Mesop ,

To fix this error, first thing first, install “Microsoft Access Database Engine 2016 Redistributable.”

https://www.microsoft.com/en-us/download/details.aspx?id=54920

And then also check the version of Excel and SSMS. They need to be same, like 32 vs 32 or 64 vs 64
SSMS is a 32 bit client, if your Microsoft Excel is 64 bit. you may need to install the 64 bit version of the Microsoft Access Database Engine 2016 Redistributable and try opening – the 64-bit “SQL Server Import and Export Data” directly. Go to Start Menu -> Microsoft SQL Server 2012( your SQL server version) -> SQL Server Import and Export Data (64-bit)> Open the application and try to import data using the “Excel 2016” option, it should work fine.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Pat Mesop 1 Reputation point

2022-06-16T18:56:45.513+00:00

Not sure which version of Excel you suggest that I check. Recall that I mentioned that I upgraded to Office 365 from Office 2016 as required by my organization and that's what caused the issue. The Excel data files were sent to me by somebody else and I am unable to reach them to determine if their Excel 2016 is 32 or 64 bits but I have Office 365 on my computer. Previous to the upgrade to Office 365 we used Office 2016 and there were no issues, however as suggested, I will install the 32 bit version of Microsoft Access Database Engine 2016 Redistributable (as my Import and Export Wizard is 32 bits) and see if it resolves the problem. I also receive the same error when I attempt to create a package in SQL Server Data Tools - SSDT that accesses the Excel files. Lastly I find it hard to comprehend that Microsoft didn't provide for backwards compatibility with older version in Office 365.

Share via

Can not longer use import and Export Wizard to import Excel version 2016 after upgrade to Office 365. Error - "..OLE DB provider Microsfoft.ACE.OLEDB. 16.0 is not registered..."

1 answer

Your answer