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

[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.