provider is not registered on the local machine.

[Shiva]

Hi all,

iam trying connect ms excel using OLEDB VBO iam getting this error "Internal : Could not execute code stage because exception thrown by code stage: The 'Provider=Microsoft.ACE.OLEDB.16.0' provider is not registered on the local machine." can anyone help me ....

 

[VJR]

Hi Shiva,

1) Which Windows version you have and
2) what is its bit - 32, 64?
3) which Ms Office version you have
4) what is its bit - 32, 64?

 

[Shiva]

Hi Vjr,

1) windows 10 64 bit but i have installed ms access db bit-32 because it is not accepting bit-64.
2) ms excel 2016 bit-64...

 

[VJR]

Hi Shiva,

I do not have a direct answer to your problem but I think the bit compatibility could be the issue.
Although the below link is for oledb 12.0 but is for 64 bit Windows and Office versions.
You may want to take a look at it.
https://social.msdn.microsoft.com/F...-registered-on-the-local-machine?forum=vstsdb

 

[Shiva]

Hi vjr,

did you try this oledb with execl can you please share that business object xml file ...

 

[VJR]

Hi Shiva,

I am seeing the same error. But based on the solution given in the above link I will need 32 bit Access Database Engine which I cannot install due to restricted access on my machine.

 

[amlan Sahoo]

Hi All,

I have the solution for this,

Download Access data base engine 2010 32-bit even though your system is 64-bit still download 32- bit then it will work fine for sure.
Below is the link to download it,
https://www.microsoft.com/en-in/download/details.aspx?id=13255
Below is the link related post for this,
https://techcommunity.microsoft.com/t5/Excel/read-excel-2016-with-c/td-p/76012

Use OLEDB 12.0
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\myFolder\myExcel2007file.xlsx;
Extended Properties="Excel 12.0 Xml;HDR=YES";