which is the better method? I have about 2000 inserts to do which comes in from a web service. should i do sql = "insert into TABLE (x, y, x) VALUES (a,b,c)" sql = sql & "insert into TABLE (x, y, x) VALUES (a,b,c)" etc with one execution or, should i call the execution of the insert after each insert command?