Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Excel 12   (RSS)

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
 
Page view tracker