DAO Access 大数据量插入
DAO.DBEngine dbEngine = new DAO.DBEngine(); DAO.Database db = dbEngine.OpenDatabase(DataPath); DAO.Recordset rs = db.OpenRecordset("CHK_ERRORLIST"); DAO.Field[] myFields = new DAO.Field[7]; myFields[0] = rs.Fields["AAA"]; myFields[1] = rs.Fields["BBB"]; myFields[2] = rs.Fields["CCC"]; int strTagKey = -1; for (int i = 0; i < aError.Count; i++) { rs.AddNew(); myFields[0].Value = aError[i].ruleId; myFields[1].Value = aError[i].errorDescription; myFields[2].Value = aError[i].errorType; rs.Update(); } rs.Close(); db.Close();
using DAO = Microsoft.Office.Interop.Access.Dao;