Search code examples
exceloffice-interopoffice-automation

Connection String for Excel 2010?

I am using OLEDB to connect to Excel 2010. What is the required connection string for this operation?

Solution

  • From here:

    Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyExcel.xls;Extended Properties="Excel 8.0;HDR=Yes;IMEX=1";

    or

    OLEDB;Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyExcel.xls;Extended Properties="Excel 8.0;HDR=Yes;IMEX=1";