Jason McKittrick's Blog

Microsoft ACE OLEDB 16.0 Error

I have had a bunch of questions about the below error.  I thought I would add a section to my blog on Errors and Workarounds that I would capture these common requests I get and show the workaround.

The below error has shown up while trying to import a Excel 2016 file into SQL Server using the import mode.

Here is a good work around that I have found to work.

Download and install the ADE Engine from this link – http://www.microsoft.com/download/en/confirmation.aspx?id=23734

Restart the import process and select Office 2007-2010 file.  Even if you have a Excel 2013 or Excel 2016 file.  This will workaround the error and import the sheets from Excel.

 

Leave a Reply

Your email address will not be published. Required fields are marked *