excel批量转sql语句

来源:互联网 发布:2016珠三角经济数据 编辑:程序博客网 时间:2024/05/19 20:22

= CONCATENATE (
“INSERT INTO approval_info(THEMIS_SEQ,CUST_NAME, INDIV_MOBILE,ID_NO,DUR_ACTIVEDURATION,real_msg) VALUES(‘” & A2 & “’,’” & B2 & “’, ‘” & C2 & “’, ‘” & D2 & “’, ‘” & E2 & “’, ‘” & F2 & “’);”
)

原创粉丝点击