locked
Connection string for XLS and XLSX file reading RRS feed

  • Question

  • User-73514677 posted

    Hi.

    What should be the connection string format to be used for XLS and XLSX file extension?

    I have files of type XLS and XLSX, in which the first row of data is header. What should be the connection string format to be used for both the types?

    I have this, but wanted to know if this works for XLS and XLSX ?

    string excelConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;"
                   + @"Data Source=filepathwithfilename;"
                   + "Extended Properties='Excel 12.0 Xml;IMEX=1;HDR=YES;TypeGuessRows=0;ImportMixedTypes=Text;MAXSCANROWS=0'";
    

    Thanks

    Tuesday, March 24, 2020 3:32 PM

Answers

All replies