excel小技巧

[啊彪123]

GZ 2000 211.136.218.133 2083.0020.200.00 "2083 0020 200 00 460" MOTO 不清楚 蔡鹏程 13922201197 不清楚 insert into t_bras_ids (BRAS_KEY, BRAS_ADDRESS, BRAS_PORT, BRAS_VENDOR, PORTAL_COMMAND, BRAS_SHAREDKEY, SPECIALFLAGS, CITY_NUMBER) values ('2083.0020.200.00','211.136.218.133',2000,'MOTO', 'Cmv2Command', '[huawei]', NULL, 'GZ');

="insert into t_bras_ids (BRAS_KEY, BRAS_ADDRESS, BRAS_PORT, BRAS_VENDOR, PORTAL_COMMAND, BRAS_SHAREDKEY, SPECIALFLAGS, CITY_NUMBER) values ('"&D2&"','"&C2&"',"&B2&",'"&H2&"', 'Cmv2Command', '[huawei]', NULL, '"&A2&"');"

[TMTYAOYAO]

啥！

[zenowolf]

数据导入