Kangzj

将Excel中的数据导出成SQL(即可导入MySQL等数据库了)

=CONCATENATE(“insert into students (school,name,stuno,gender,grade,mobile)values(“,”‘”,A771,”‘”,”,”,”‘”,A771,”‘”,”,”,”‘”,A771,”‘”,”,”,”‘”,A771,”‘”,”,”,”‘”,A771,”‘”,”,”,”‘”,A771,”‘”,”);”)

把上面的语句在单元格中输入，然后，将A771换成相应的单元格的编号即可，然后拖动就行了！

© 2009, kangzj. 版权所有.