locked
Microsoft.Jet.OLEDB.4.0 provider is not registered on the local machine RRS feed

  • General discussion

  • Ok...So I am attempting to read a .xls file using a C# Edit Script and this command...

    string StringConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + sourceFile + ";Extended Properties=\"Excel 8.0;HDR=Yes;IMEX=1\"";

    And I got this error...

    "Microsoft.Jet.OLEDB.4.0 provider is not registered on the local machine"

    My local client machine has "System type: 64-bit Operating System"

    I found this link which helped somewhat...


    http://social.msdn.microsoft.com/Forums/sqlserver/en-US/25e98f9d-068d-4eb5-b15a-256f32f41523/provider-cannot-be-found-it-may-not-be-properly-installed-microsoftjetoledb40?forum=sqldataaccess

    Which points me to...

    http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=13255

    Sooooo  do I now try and install "AccessDatabaseEngine_x64.exe???

    And if so, is my command to open and access a .xls, and I stress .XLS, the following...

    string StringConnection = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + sourceFile + ";Extended Properties=\"Excel 12.0;HDR=Yes;IMEX=1\"";

    Soooooo confusing.....



    I appreciate anyone's help on this stumbling block.

    Thanks!

    ITBobby85@gmail.com
    Thursday, September 11, 2014 11:30 PM

All replies

  • Yes, you need to install ACE provider. This will help you with the connection strings.

    Satish Kartan http://www.sqlfood.com/

    Friday, September 12, 2014 3:33 AM