Excel生成insert 语句

 

选中表格最后一行，改为自己需要的数据，然后选中需要填充的行，比如   J1:J200 按下Ctrl+D，即可完成填充，生成insert语句，复制出来即可执行。

=CONCATENATE("insert into 表名 (列1,列2,列3) values ('",A1,"','",B1,"','",C1,"');")

 

来个excle加长版自取：

（'",A1,"','",B1,"','",C1,"','",D1,"','",E1,"','",F1,"','",G1,"','",H1,"','",I1,"','",J1,"','",K1,"','",L1,"','",M1,"','",N1,"','",O1,"','",P1,"','",Q1,"','",R1,"','",S1,"','",T1,"','",U1,"','",V1,"','",W1,"','",X1,"','",Y1,"','",Z1,"','",AA1,"','",AB1,"','",AC1,"','",AD1,"','",AE1,"','",AF1,"','",AG1,"','",AH1,"','",AI1,"','",AJ1,"','",AK1,"','",AL1,"','",AM1,"','",AN1,"','",AO1,"','",AP1,"','",AQ1,"','",AR1,"','",AS1,"','",AT1,"','",AU1,"','",AV1,"','",AW1,"','",AX1,"','",AY1,"','",AZ1,"','",BA1,"','",BB1,"','",BC1,"','",BD1,"','",BE1,"','",BF1,"','",BG1,"','",BH1,"','",BI1,"','",BJ1,"','",BK1,"','",BL1,"','",BM1,"','",BN1,"','",BO1,"','",BP1,"','",BQ1,"','",BR1,"','",BS1,"','",BT1,"','",BU1,"','",BV1,"','",BW1,"','",BX1,"','",BY1,"','",BZ1,"',）

 

 

标签: sql, insert, Excel