Help
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

OleDB for Excel - Provider is Not Registered

Go to answer
Anonymous
Not applicable

‎08-12-17 12:19 AM

I'm working on a process that's using the Utility Data - OLEDB object. I set up my process based on the Learning Guide Blue Prism - Data OLEDB. I've continued to have the error "Provider=Microsoft.ACE.OLEDB.12.0" provider is not registered on the local machine. Based on the Learning Guide I completed the 2 downloads to fix this issue, and I used the recommendations found on the www.connectstring.com/excel/. None of these have corrected the error and I'm not sure what else to do. Help Please. Thanks.
0 Likes
1 BEST ANSWER

Helpful Answers

Go to answer
Denis__Dennehy
Level 16

‎15-12-17 05:41 PM

Firstly I would recommend trying to connect to your OLEDB datasource using a product other than Blue Prism - to validate that the issue is environmental rather than anything to do with the OLEDB VBO. I usually use Excel for this. Next - if you prove it is a VBO issue maybe go to the Blue Prism support team for help. If it is an environment issue then I guess lots of google searching is required to figure out why your ODBC driver installation is not working - it might be worth uninstalling and reinstalling the data source driver just in case it is an install issue.

View answer in original post

0 Likes
4 REPLIES 4

Go to answer
Rama_RajuGK
Level 3

‎13-12-17 05:27 PM

Hi, you can refer the below , this generally means the OLEDB provider is not properly installed on the client machine. See https://social.msdn.microsoft.com/Forums/en-US/1d5c04c7-157f-4955-a14b-… for further details.
0 Likes

Go to answer
Anonymous
Not applicable
In response to Rama_RajuGK

‎14-12-17 01:59 AM

Hi. I already when through the steps on that website twice, and it's still not working.
0 Likes

Go to answer
Anonymous
Not applicable

‎14-12-17 10:59 PM

I went through the website again and the object still doesn't work. Any other recommendations?
0 Likes

Go to answer
Denis__Dennehy
Level 16

‎15-12-17 05:41 PM

Firstly I would recommend trying to connect to your OLEDB datasource using a product other than Blue Prism - to validate that the issue is environmental rather than anything to do with the OLEDB VBO. I usually use Excel for this. Next - if you prove it is a VBO issue maybe go to the Blue Prism support team for help. If it is an environment issue then I guess lots of google searching is required to figure out why your ODBC driver installation is not working - it might be worth uninstalling and reinstalling the data source driver just in case it is an install issue.
0 Likes