odbc
string str = @"Driver=Microsoft Excel Driver (*.xls);Dbq=c:/abc.xls;";
con = new OdbcConnection(str);
da = new OdbcDataAdapter("select * from [sheet1$]", con);
dt = new DataTable();
da.Fill(dt);
dataGrid1.DataSource = dt;
oledb
string str = @"Provider=Microsoft.Jet.OleDb.4.0;Data Source=c:/abc.xls;Extended Properties=Excel 8.0;";
con = new OleDbConnection(str);
da = new OleDbDataAdapter("select * from [sheet1$]", con);
dt = new DataTable();
da.Fill(dt);
dataGrid1.DataSource = dt;