Savance Enterprise Support

When you attempt to use the Import feature built into Microsoft SQL Management Studio and you attempt to import an XLSX file, the system let's you point to it and select it, but then throws a "microsoft.ace.oledb.12.0" error.  When this occurs, you need to download and install this:

https://www.microsoft.com/en-us/download/confirmation.aspx?id=23734

If that still does not work, you may need to download/install this:

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

The issue is that the server/PC needs the ability to open Excel 2007 or higher files and files are required from Microsoft to support this.  Here is a reference link to the article that details it in a forum:

https://social.msdn.microsoft.com/Forums/en-US/1d5c04c7-157f-4955-a14b-41d912d50a64/how-to-fix-error-the-microsoftaceoledb120-provider-is-not-registered-on-the-local-machine?forum=vstsdb

https://stackoverflow.com/questions/6649363/microsoft-ace-oledb-12-0-provider-is-not-registered-on-the-local-machine

https://blog.sqlauthority.com/2015/06/24/sql-server-fix-export-error-microsoft-ace-oledb-12-0-provider-is-not-registered-on-the-local-machine/

The exact error thrown by SQL Management Studio is "'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine"