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

Discussion in 'ASP.NET / ASP.NET Core' started by amolr, Nov 1, 2011.

  1. amolr

    amolr

    Hi All,

    I am trying to read excel file and performing some operations. It works fine for local host but causes error when doing on remote server.

    I have install access database engine on server and changed connection string as follows

    original :-

    FileConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + FullFilePath + "; Extended Properties=Excel 8.0;";



    changed to:-

    FileConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + FullFilePath + ";Extended Properties=\"Excel12.0HDR=YES;\"";



    but still getting error as



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





    kindly suggest solution asap.

    Thanks.
     
    amolr, Nov 1, 2011
    #1
  2. Bruce

    Bruce DiscountASP.NET Staff

    Can you post the URL that generate this error?
     
    Bruce, Nov 1, 2011
    #2

Share This Page