How to registered in this issue

Posted by Jayakumars under ADO.NET on 12/4/2017 | Points: 10 | Views : 114 | Status : [Member] [MVP] | Replies : 1
Hi
In my code excel ole.db connection string

this is my code

connectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + fileLocation + ";Extended Properties=\"Excel 12.0;HDR=Yes;IMEX=2\"";

but i meet this issue this is error

The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine

I have also installed corresponding provider exe in my pc but this issue not fixed

any one guide me how to fix this?

Mark as Answer if its helpful to you


Responses

Posted by: Sheonarayan on: 12/4/2017 [Administrator] HonoraryPlatinum | Points: 25

Up
0
Down
See if you have installed correct and correct version of OLEDB provider.

Also check the connection string, I think connection string has ACE that should not be.

Thanks

Regards,
Sheo Narayan
http://www.dotnetfunda.com

Jayakumars, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response