How to registered in this issue

Posted by Jayakumars under ADO.NET on 12/4/2017 | Points: 10 | Views : 804 | Status : [Member] [MVP] | Replies : 1

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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

Kumaraspcode2009@gmail.com

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

Latest Posts