excel生成sql,

1，先在excel的標題行拼接sql

="INSERT into BasicInfo (name,gender,birthday,IsPremature,predicted,race,contact,admin_id)VALUES('"&A3&"','"&D3&"','"&B3&"','0','','汉族','"&C3&"','149'"&")"

="select  * from  BasicInfo where name='"&A2&"' and gender='"&D2&"'and birthday='"&B2&"' and admin_id='149'"

="IF NOT EXISTS (SELECT * FROM BasicInfo WHERE name ='"&A2&"' and CONVERT(VARCHAR, birthday, 23) ='"&E2&"') BEGIN
    INSERT INTO BasicInfo (name,gender, birthday,IsPremature,predicted,race,admin_id) VALUES ('"&A2&"','"&D2&"','"&E2&"','0','','汉族','123') END"

3,更新

="update  physiquedata2  set Extend3  ='"&A2&"' where Id= '"&B2&"' "

2，点击fx选择函数CONCATENATE,Text1中固定列，Text2，Text4为值

4,身份证转换为出生日期

 =TEXT(MID(F3,7,4)&"-"&MID(F3,11,2)&"-"&MID(F3,13,2),"YYYY-MM-DD")

3，时间的转换

=TEXT(E2,"yyyy-MM-dd")