Support Suite

Importing Excel Spreadsheet into SQL to Manually Merge or Import Data gives microsoft.ace.oledb.12.0 Error

Posted by Steve Bardocz on 02 August 2017 05:55 PM

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"

Comments (0)

Post a new comment Reply to comment
Post a new comment Reply to comment

Full Name:
Email:
Comments:

CAPTCHA Verification
CAPTCHA Verification

Please enter the text you see in the image into the textbox below. This is required to prevent automated registrations and form submissions.

Savance | The Company

Savance sets ourselves apart from our competition by keeping it personal. We actively request feedback, know our customers by first name, integrate their ideas into our products, and measure our success based on their happiness. The way businesses used to be run.