using System.Data;
using System.Data.OleDb;
...
OleDbConnection con = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Book1.xls;Extended Properties=Excel 8.0");
OleDbDataAdapter da = new OleDbDataAdapter("select * from[Sheet1$]", con);
DataTable dt = new DataTable();
da.Fill(dt);
this is how i work with sheet1 but now i want to take from two or more sheets so how i need to do that