How to convert MDB to SQLite in Android

Question

I have one Microsoft Access .MDB file and want to use that database in an Android application.

How can I convert the .mdb database to SQLite?

Answer 1

You need to use some tools to convert database, refer to supported list softwares that do the job you need here: http://www.sqlite.org/cvstrac/wiki?p=ConverterTools

Answer 2

You can write your own - it's not very difficult

1. Install SQlite on your desktop - just go to sqlite.org
2. Get JDBC access to SQLite (there're a lot of JDBC drivers for SQLite)
3. Get JDBC access to your MDB (MS-Access) using JDBC (common JDBC-ODBC bridge driver is ok)
4. Voilà!