string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;
Data Source=D:/test.xls;"+ "Extended Properties='Excel 8.0'";
DataSet ds = new DataSet();
OleDbDataAdapter oada = new OleDbDataAdapter("select * from [Sheet1$]", strConn);
oada.Fill(ds);
string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;
Data Source=D:/test.xls;"+ "Extended Properties='Excel 8.0'";
DataSet ds = new DataSet();
OleDbDataAdapter oada = new OleDbDataAdapter("select * from [Sheet1$]", strConn);
oada.Fill(ds);