'Microsoft.ACE.OLEDB.12.0' error trying to import Excel file into SSMS

Question

I'm trying to import an XLSX file into SSMS v18.9.2. My version of Office is 365 for Enterprise.

When I try and import the file I get the error "The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. (System.Data)".

I've seen elsewhere that the solution is to download the Access Database Engine. I downloaded the 64 bit one, installed it, and it didn't fix anything. When I try and install the other (32 bit) version it gives me a message "Cannot install the 32 bit version because you have 64 bit Office products."

So... stuck at the moment. Any help is appreciated -- thank you!

Answer 1

Of course, as soon as I post this I find a download that helped: https://download.cnet.com/2007-Office-System-Driver-Data-Connectivity-Components/3000-10254_4-75452798.html

If there's a solution that doesn't require CNet, though, happy to hear it!

Answer 2

Hi @King, Arthur ,

Directly from Microsoft:

Microsoft Access Database Engine 2010 Redistributable Download
http://www.microsoft.com/en-us/download/details.aspx?id=13255