1
2
3
4
5
6
7
8
9
10

string connectionString = string.Format("Provider = Microsoft.Jet.OLEDB.4.0; data source =
                                                                   {0};Extended Properties=Excel 8.0;",file);
 
OleDbDataAdapter = new OleDbDataAdapter("SELECT * FROM [TABLES1$]",connectionString);
 
DataSet ds = new DataSet();
 
adapter.Fill(ds,"Name");
 
DataTable dt = ds.Tables["Name"];