if (extn.ToUpper() == ".XLS") { excelConn = @"Provider=Microsoft.Jet.Oledb.4.0; Data Source=" + path + "; Extended Properties=Excel 8.0;"; } if (extn.ToUpper() == ".XLSX") { excelConn = @"Provider=Microsoft.ACE.Oledb.12.0; Data Source=" + path + "; Extended Properties=Excel 12.0;"; }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)