C# 连接access并存至datatable中

OleDbConnection conn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:/test/db1.mdb");conn.Open();string sql = "SELECT * from yourTable";OleDbDataAdapter adp = new OleDbDataAdapter(sql, conn);DataTable dtEmployee = new DataTable();adp.Fill(dtEmployee);