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;

 

posted @ 2020-11-25 14:34  天要下雨娘要嫁人  阅读(153)  评论(0)    收藏  举报