How to registered in this issue

Posted by Jayakumars under ADO.NET on 12/4/2017 | Points: 10 | Views : 1423 | Status : [Member] [MVP] | Replies : 1
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


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

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.


Sheo Narayan

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

Login to post response