Excel to DataTable

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