🚀 go-pugleaf

Hi

    I am using an TADOQuery component to open a table in an MS Access
database and write about 150,000 new records to the table. The code I use is
below and it takes too long to write all the records to the database about 5
minutes. The Append() and Post() functions seems to cause the bottle neck
whenever that line of code is commented out . How can I fix my code so that
the records will be written to the database in an acceptable time limit.
                C1 = CustLoc.begin();
                while(C1! = CustLoc.end()) {
                        ADOQuery2->Append();
                        ADOQuery2->FieldValues["ServiceID"] = E1->first;
                        ADOQuery2->FieldValues["X"] = C1->second.X;
                        ADOQuery2->FieldValues["Y"] = C1->second.Y;
                        ADOQuery2->FieldValues["NodeID"] =
C1->second.NodeID;
                        ADOQuery2->FieldValues["LegID"] = C1->second.LegID;
                        ADOQuery2->Post();
                        ++C1;
            }