SQL code to insert multiple rows in ms-access table
- by Thierry
I'm trying to speed up my code and the bottleneck seems to be the individual insert statements to a Jet MDB from outside Access via ODBC. I need to insert 100 rows at a time and have to repeat that many times.
It is possible to insert multiple rows in a table with SQL code? Here is some stuff that I tried but neither of them worked. Any suggestions?
INSERT INTO tblSimulation (p, cfYear, cfLocation, Delta, Design, SigmaLoc,
Sigma, SampleSize, Intercept) VALUES
(0, 2, 8.3, 0, 1, 0.5, 0.2, 220, 3.4),
(0, 2.4, 7.8, 0, 1, 0.5, 0.2, 220, 3.4),
(0, 2.3, 5.9, 0, 1, 0.5, 0.2, 220, 3.4)
INSERT INTO tblSimulation (p, cfYear, cfLocation, Delta, Design, SigmaLoc,
Sigma, SampleSize, Intercept) VALUES
(0, 2, 8.3, 0, 1, 0.5, 0.2, 220, 3.4) UNION
(0, 2.4, 7.8, 0, 1, 0.5, 0.2, 220, 3.4) UNION
(0, 2.3, 5.9, 0, 1, 0.5, 0.2, 220, 3.4)
