要自己写个Parser一行一行读进来,parse,然后做成Insert SQL, 写到数据库里。
如果是CSV, 有些DB可以直接Import的。
CSV 例子:
ID,Name
1,SS
2,HJ
3,GGXX
4,QQQ
No need lah....
1) Load your data into Excel (then you can have all sorts of options on how to split your flat file into data entries.
2) Save your data from Excel as CSV
3) Import into your database.
2) Save your data from Excel as CSV
3) Import into your database.