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

[ions]

Hello Access Forum,

I am unable to import Excel into my SQL Server due to the error 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. (System.Data)

1) By running EXEC sp_enum_oledb_providers I can see I have Microsoft.ACE.OLEDB.12.0. on my machine.

2) It's located at this path:

C:\Program Files\Microsoft Office\root\vfs\ProgramFilesCommonX64\Microsoft Shared\OFFICE16

3) When I run regserve32 ACEOLEDB.DLL I get the below error message.

4) ChatGPT recommends I download the Microsoft Access Database Engine 2016 Redistributable at the below URL which I prefer not to do because I already have MS Access 2019 installed. That being said are there any other steps I can take without downloading the Redistributable?

Microsoft Access Database Engine 2016 Redistributable

Thank you for your feeback.

 

[Uncle Gizmo]

I note your question has yet to receive a reply, hence I am bumping it up the list so that it gets another look.

 

[arnelgp]

just maybe you are using x32 program and you have x64 mso?

 

[GPGeorge]

Hello Access Forum,

I am unable to import Excel into my SQL Server due to the error 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. (System.Data)

Spoiler:

View attachment 115772

1) By running EXEC sp_enum_oledb_providers I can see I have Microsoft.ACE.OLEDB.12.0. on my machine.

View attachment 115773



2) It's located at this path:

C:\Program Files\Microsoft Office\root\vfs\ProgramFilesCommonX64\Microsoft Shared\OFFICE16

View attachment 115774

3) When I run regserve32 ACEOLEDB.DLL I get the below error message.

View attachment 115776

4) ChatGPT recommends I download the Microsoft Access Database Engine 2016 Redistributable at the below URL which I prefer not to do because I already have MS Access 2019 installed. That being said are there any other steps I can take without downloading the Redistributable?

Microsoft Access Database Engine 2016 Redistributable

Thank you for your feeback.

I am reasonably sure that ChatGPT is on the right track.

A few clarifying details might be in order, though.

Has this ever worked in the past? Is this a newly surfaced problem?

What version and build of Access do you have installed? Did you recently get an Office update on this computer?

 

[Gasman]

Could try these steps? They appear to be mentioned in several clips.

 

[Charax]

I just resolved a somewhat similar problem that required deleting Office, installing Access 2016 Runtime, deleting Runtime, reinstalling Office.

Very clunky, brute force. But maybe gives you ideas at my thread on Error Installing SSMA. (Sorry, don't know how to link threads yet.)

 

[Gasman]

Sorry, don't know how to link threads yet.

Even if you did, you would not be able to, for a few more posts yet.

 

[ions]

I don't import Excel directly into SQL Server anymore. I first import into MS Access, cleanup the data in MS Access and then import into SQL Server using the Migration Assistant. The Migration Assistant creates the indexes and the timestamp field for me. This appears to be the best approach for me.

I never use the MS Access Table Link feature in the Migration Assistant. Once you do that the Migration Assistant will ignore those tables going forward if you ever try to re-import them. I always manually link the tables in MS Access .