what is the best way to convert access mdb file to sqlite database?

[mismael85]

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?

[wysota]

Google for "export mdb to sql".