Share via

Office 365 Excel Proplus , OLEDB connectionstring

Anonymous
2020-03-12T12:38:55+00:00

Our customers upgraded to Office 365 Excel Proplus and send excel files

We read excel file using OleDB connection, all lower version are working

we had a workaround 

  • Installed Microsoft Access 2016 Runtime
  • Installed Microsoft Access Database Engine 2016
  • Modified connection string
    • Provider=Microsoft.ACE.OLEDB.16.0;Data Source="d:\temp.xlsx";Extended Properties="Excel 16.0 Xml;HDR=True;IMEX=0

Tyring to open OleDBConnection.Open()

it throws exception "IErrorInfo.GetDescription failed with REGDB_E_CLASSNOTREG(0x80040154)."

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2020-03-12T14:56:13+00:00

    Hi Mojesh,

    Based on your description, when you try to  read Excel file via OleDB connection, an error message will pop up.

    You mentioned you installed Microsoft Access 2016 Runtime and Microsoft Access Database Engine 2016, are these two the same bit version as Excel?

    If not, please make sure they are all the same bit version.

    If yes, you can try to re-install them or install Microsoft Access 2010 Runtime to check whether the problem persists.

    If the problem persist, please feel free to post back.

    Best regards,

    Jazlyn

    0 comments
  2. Anonymous
    2020-03-13T11:14:25+00:00

    Hi Mojesh,

    Based on your description, when you try to  read Excel file via OleDB connection, an error message will pop up.

    You mentioned you installed Microsoft Access 2016 Runtime and Microsoft Access Database Engine 2016, are these two the same bit version as Excel?

    If not, please make sure they are all the same bit version.

    If yes, you can try to re-install them or install Microsoft Access 2010 Runtime to check whether the problem persists.

    If the problem persist, please feel free to post back.

    Best regards,

    Jazlyn

    Thanks Jazlyn

    • unistalled Microsoft Access 2016 Runtime
    • Installed Microsoft Access 2010 Runtime
    • Checked and confirmed all (Office 365 Excel Proplus, Microsoft Access 2010 Runtime & Microsoft Access Database Engine 2016) have the same 32-bit version

    Tried all possible

    Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\Temp.xlsx;Extended Properties="Excel 12.0 Xml;HDR=True;IMEX=0";

    >Error : External table is not in the expected format.

    Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\Temp.xlsx;Extended Properties="Excel 16.0 Xml;HDR=True;IMEX=0";

    >Error: Could not find installable ISAM.

    Provider=Microsoft.ACE.OLEDB.16.0;Data Source=D:\Temp.xlsx;Extended Properties="Excel 12.0 Xml;HDR=True;IMEX=0";

    >Error: External table is not in the expected format.

    0 comments
  3. Anonymous
    2020-03-14T09:26:47+00:00

    Hi Mojesh,

    I tried to find a lot of information about this error. The connection string should be correct now.

    The problem may be that the Excel file format does not meet the requirements.

    It is recommended that you can check if there is any blank column, or there is no data from Cell A1.

    Or you can try to remove the parameters HDR = True; IMEX = 0 to check if it works.

    Best regards,

    Jazlyn

    0 comments
  4. Anonymous
    2020-03-16T12:36:17+00:00

    Hi Mojesh,

    Has the problem about OleDB connection in Excel been solved?

    Best regards,

    Jazlyn

    0 comments