mismael85
21st December 2010, 14:06
Hi,
I am trying to convert access *.mdb file to sqlite database so i used the following technique
1- read the tables that are exist in the access file
2- create those tables in the sqlite file using sql query(i.e. CREATE TABLE ....)
3- reading the data from the table in the access database using SQL query (SELECT * from table)
4- writing these data to sqlite table record by record using the SQL query(INSERT INTO table)
what i am facing here is the speed of the conversion, it takes a long time.
is there a better way?
I am trying to convert access *.mdb file to sqlite database so i used the following technique
1- read the tables that are exist in the access file
2- create those tables in the sqlite file using sql query(i.e. CREATE TABLE ....)
3- reading the data from the table in the access database using SQL query (SELECT * from table)
4- writing these data to sqlite table record by record using the SQL query(INSERT INTO table)
what i am facing here is the speed of the conversion, it takes a long time.
is there a better way?