如果从excel表中导出insert-sql

=CONCATENATE("INSERT INTO p_act_lottery(actId,status,grantWay,createTime,invalidTime,amount,prizeType,bargNo,userType,bargType,userCode,userId,actPhone) VALUES(14,1,5,CAST('"&F2&"' AS DateTime),'2019-01-09 23:59:59','"&D2&"',1,'"&A2&"',3,1,'"&B2&"','"&C2&"','"&E2&"')")

原文地址:https://www.cnblogs.com/shijianchuzhenzhi/p/9811874.html