(用SQLite Expert Professional 工具)
首先要下载SQLite Expert Professional 工具,新建一个数据库,然后就可以按照下面的步骤将access数据库转换成sqlite数据库了。
通过SQLite Expert创建数据库,然后import --〉Data Transfer Wizard--〉import data into...--〉ADO Data Source
输入
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\XKTV_2012_0515.mdb;Persist Security Info=False
(即:你的数据库存放的路径)
用户名和密码不用输 直接确定就好了
之后,一路next就好,刚开始在网上查了很多方法,但是都太繁琐,而且转换之后中文的编码格式自动转变,不方便,这个方法应该是目前最好的了,呵呵...
http://download.csdn.net/download/zhq56030207/3318317
select * from tmp
select t_hanzi_pinlv.frq, t_hanzi_pinlv.hanzi from t_hanzi_pinlv , t_bihua2hanzi where t_bihua2hanzi.hanzi = t_hanzi_pinlv.hanzi;
select a.frq, b.hanzi into tmp111 from t_hanzi_pinlv as b , t_bihua2hanzi as a where a.hanzi = b.hanzi;
insert into tmp select t_bihua2hanzi.hanzi, t_bihua2hanzi.bihua, t_hanzi_pinlv.pinlv from t_hanzi_pinlv , t_bihua2hanzi where t_bihua2hanzi.hanzi = t_hanzi_pinlv.hanzi;
delete from tmp;
select * from t_bihua2hanzi;
select * from t_bihua2hanzi , tmp where t_bihua2hanzi.hanzi = tmp.hanzi;
update t_bihua2hanzi set frq = tmp.frq where t_bihua2hanzi.hanzi in (select ) tmp.hanzi;
update t_bihua2hanzi set frq =1 where hanzi = '耱'
select * from tmp where bihua like '12%' order by frq DESC ;
select * from t_hanzi_pinlv where hanzi = '可';