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'"

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

3，时间的转换

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