excel 转化sql

人员档案：=CONCATENATE(“insert into rsdagl_rydaxxb(grbh,sfzhm,xb,xm,csrq,lxdh,sjhm,txm)values (’”&A2&"’,’"&B2&"’,’"&C2&"’,’"&D2&"’,’"&E2&"’,’"&F2&"’,’"&G2&"’,’"&H2&"’);")
暂存档案：=CONCATENATE(“insert into rsdagl_ld_zcdab (zcid,jgid,dwdjid,zcbh,xb,xm,csrq,ddrq,lxdh,sjhm,zcdjrq,dazt,syjg,czybmid,kfid,dagid,dalyfs,drlx,zrdw,dagxh,sfyzsjd,sydxzqh,czyid,wtdabs,txm)values (’”&A2&"’,’"&B2&"’,’"&C2&"’,’"&D2&"’,’"&E2&"’,’"&F2&"’,’"&G2&"’,’"&H2&"’,’"&I2&"’,’"&J2&"’,’"&K2&"’,’"&L2&"’,’"&M2&"’,’"&N2&"’,’"&O2&"’,’"&P2&"’,’"&Q2&"’,’"&R2&"’,’"&S2&"’,’"&T2&"’,’"&U2&"’,’"&V2&"’,’"&W2&"’,’"&X2&"’,’"&Y2&"’);")
基础库：=CONCATENATE(“insert into bip(BIP_ID,BIP_CITIZENID,BIP_NAME,BIP_SEX,BIP_BIRTHDAY)values (’”&A34&"’,’"&B34&"’,’"&C34&"’,’"&D34&"’,’"&E34&"’);")
正式库：=CONCATENATE(“insert into rsdagl_ld_cdryb(cdid,grbh,cdlx,dwdjid,cdrq,fwzt,cdbh,szhzt,dazt,czyid,czybmid,kfid,dagid,dagxh,dalyfs,zrdw)values (’”&A2&"’,’"&B2&"’,’"&C2&"’,’"&D2&"’,’"&E2&"’,’"&F2&"’,’"&G2&"’,’"&H2&"’,’"&I2&"’,’"&J2&"’,’"&K2&"’,’"&L2&"’,’"&M2&"’,’"&N2&"’,’"&O2&"’,’"&P2&"’);")
档案审核信息:=CONCATENATE(“insert into rsdagl_ld_dashxxb(shid,grbh,wtcddwbh,zcid,shjg,sfdqjl,cdid,czyid,czybmid,shrq)values (’”&A2&"’,’"&B2&"’,’"&C2&"’,’"&D2&"’,’"&E2&"’,’"&F2&"’,’"&G2&"’,’"&H2&"’,’"&I2&"’,’"&J2&"’);")
档案入库信息:=CONCATENATE(“insert into rsdagl_ld_darkjlb(rkid,cdid,rklx,kflx,rksqrq,sqczybmid,sqczsj,sfqr,rkqrrq,qrsfyx,qrczybmid,qrczsj,kfid,dagid,ph)values (’”&A2&"’,’"&B2&"’,’"&C2&"’,’"&D2&"’,’"&E2&"’,’"&F2&"’,’"&G2&"’,’"&H2&"’,’"&I2&"’,’"&J2&"’,’"&K2&"’,’"&L2&"’,’"&M2&"’,’"&N2&"’,’"&O2&"’);")
档案学历信息:=CONCATENATE(“insert into rsdagl_xlxxb(xlbh,grbh,whcd,byyx,sxzy,sfzgxl,czyid,czybmid,sfdexl)values (’”&A2&"’,’"&B2&"’,’"&C2&"’,’"&D2&"’,’"&E2&"’,’"&F2&"’,’"&G2&"’,’"&H2&"’,’"&I2&"’);")

日期转换
函数：=TEXT(F2,“yyyymmddhhmmss”)；
转换前：2020/20/02 0000
转换后：20202002000000