excel利用公式转换成sql语句:在excel字段的最后一句话添加=CONCATENATE("insert into HR_DATA_SUMMARY(ID,ASSETSNUM,ENTERPRISE_ID,CREATOR) values('",A2,"','",B2,"','",C2,"','",D2,"');") ,如图所示,最后往下一拉完美生成sql,
excel利用公式转换成sql语句:在excel字段的最后一句话添加=CONCATENATE("insert into HR_DATA_SUMMARY(ID,ASSETSNUM,ENTERPRISE_ID,CREATOR) values('",A2,"','",B2,"','",C2,"','",D2,"');"),如图所示,最后往下一拉完美生成sql,最后将sql粘贴到数据库中运行即可...