我试图加快我的代码,瓶颈似乎是通过的ODBC从外部Access到Jet MDB单独插入句子。我需要一次插入100行,必须重复很多次。% @$ J2 h2 I, G
是否可用SQL多行插入代码?这是我尝试过的一些方法,但它们都不起作用。有什么建议?
6 f! y; u ?, F kINSERT 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) u: a& n: J& m) b9 R! h2 R
解决方案: |