id name .........等等
1 小明 .........等等
转化sql语句:
=CONCATENATE("INSERT INTO game_class ('id', name, vendor, game_type, game_class, menu_level1, menu_level2, Background_name, Background_type) VALUES (' "&A1&" ',' "&B1&" ',' "&C1&" ',' "&D1&" ',' "&E1&" ',' "&F1&" ',' "&G1&" ',' "&H1&" ',' "&I1&" ');")
代码中的game_class
#要转化的excel表名,根据自己的表名来写