>string sExcelConnString = > "provider=Microsoft.Jet.OLEDB.4.0; data source='" + sFileName + " '; " + "Extended Properties=Excel 8.0;"; >>then it works fine.
>string sExcelConnString = > "provider=Microsoft.Jet.OLEDB.4.0; data source='" + sFileName + " '; " + "Extended Properties=Excel 8.0;Hdr=Yes"; >>
string sExcelConnString = "provider=Microsoft.Jet.OLEDB.4.0; data source='" + sFileName + " '; " + "Extended Properties=""Excel 8.0;Hdr=Yes""";