=CONCATENATE("insert into teacher(ID, NAME, ADDRESS) values (‘",A1,"‘,‘",B1,"‘,‘",C1,"‘);")
Excel数据生成SQL insert语句
原文:http://kxtand.blog.51cto.com/4227129/1704951