Querying Excel11 and Excel12 files

An excel11 (.xls) file can be very easily queried using “Jet OLEDB 4.0″ provider. C# snippet code for quering excel11 files is as follows,   String strConn = @”Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Sample.xls;Extended Properties=Excel 8.0”; OleDbConnection objConn = new OleDbConnection(strConn); DataTable dtObject = new DataTable(); objConn.Open(); OleDbCommand objComm = new OleDbCommand(“select * from [SummarySheet$A48:M500]”, objConn); OleDbDataReader objReader =…

0