question

KingArthur-3096 avatar image
0 Votes"
KingArthur-3096 asked TracyLiang-0256 commented

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

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!

sql-server-general
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

KingArthur-3096 avatar image
0 Votes"
KingArthur-3096 answered TracyLiang-0256 commented

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!

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

The link failed to be open now, please kindly check it if possible. Thanks!

0 Votes 0 ·
YitzhakKhabinsky-0887 avatar image
0 Votes"
YitzhakKhabinsky-0887 answered

Hi @KingArthur-3096,

Directly from Microsoft:

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.