Connection string for XLS and XLSX file reading

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

Answer 1

User475983607 posted

See the following site.

https://www.connectionstrings.com/excel/

Answer 2

User-821857111 posted

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

Have you tried it?