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.