Excel插入sql语句

SQL语句

INSERT INTO SDHXEM.HX_WAREHOUSE_MRL VALUES(SYS_GUID(), '1111111', '青青原上草\11111111', '11111111', 
185, '402881649048f10d01904e0489491e26', '402881649048f10d01904e04894b1e27', 0, '022023680', 
SYSDATE, '022023680', SYSDATE, 0, 'D-2-14',NULL, NULL, NULL, NULL, NULL, NULL, NULL,
 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '-1', '-1', '0');

EXCEL公式

="INSERT INTO SDHXEM.HX_WAREHOUSE_MRL
VALUES(SYS_GUID(), '"&B2&"', '"&C2&"', '"&D2&"', "&E2&", '402881649048f10d01904e0489491e26', '402881649048f10d01904e04894b1e27', 0, '022023680', SYSDATE, '022023680', SYSDATE, 0, '"&A2&"',' "&F2&"', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '-1', '-1', '0');"

• sql语句需要用双引号="sql语句"括起来
• 引用单元格格式为"&A1&",如果是字符串类型的要用单引号’'括起来