SQL code to insert multiple rows in ms-access table
Posted
by Thierry
on Stack Overflow
See other posts from Stack Overflow
or by Thierry
Published on 2009-07-31T14:43:11Z
Indexed on
2010/04/19
16:13 UTC
Read the original article
Hit count: 525
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)
© Stack Overflow or respective owner
