1.保留excel數(shù)據(jù)中需要的字段,刪除無關字段.

2.將excel另存為cvs格式文件.<另存名稱如：jizhan.cvs 則導入后表名即為jizhan>

3.看下圖，新建數(shù)據(jù)庫，命名為jizhan_c

4.右鍵點擊新建的數(shù)據(jù)庫——import text file（cvs，tsv）即可導入數(shù)據(jù)

5.下圖分別為xlsx文件，cvs文件，數(shù)據(jù)庫表的展示

6.數(shù)據(jù)導入時(新建數(shù)據(jù)表)自動生成了RecNo（創(chuàng)建數(shù)據(jù)庫

db.execSQL("create table if not exists jizhan(Cellname varchar(150)," +
"Longitude varchar(50)," +
"Latitude varchar(50)," +
"PCI varchar(40))")

）.

-----------------------------------------------------------------------------------

----------------------------------------------

--------------------------------------------------------------------------