The 'Microsoft.ACE.OLEDB.15.0' provider is not registered on the local machine. (System.Data) When Trying to Import Excel 2013 file into SSMS 18

user_10343353 0
Viewed 3184

I am getting the error in SSMS 18 when trying to import an excel file to a database:

The operation could not be completed.

ADDITIONAL INFORMATION:

The 'Microsoft.ACE.OLEDB.15.0' provider is not registered on the local machine. (System.Data)

When googling around for solutions, everyone seemed to have conflicting versions (64 vs. 32) but everything I am using is 64-bit.

System details:

  • Windows 10 x64-bit
  • Microsoft SQL Server Management Studio 18 (Standard Edition (64-bit))
  • Microsoft Excel 2013 64-bit

enter image description here

ssms excel sql-server
1 Answers

To check what 64-bit ACE provider is installed on the machine, just execute the following command in SSMS:

T-SQL

EXEC master.sys.sp_MSset_oledb_prop;

You can see its screen shot below.

Overall, there are 3 existing versions of ACE: 12.0, 15.0, and 16.0 You can change a misleading Excel version: dropdown to one of them, i.e to whatever version is installed.

If you need to install any of the ACE providers:

enter image description here

user_19323110
Related