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.