Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to convert MDB to SQLite in Android

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?

like image 847
mayur rahatekar Avatar asked Feb 03 '26 03:02

mayur rahatekar


2 Answers

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

like image 151
Pete Houston Avatar answered Feb 04 '26 21:02

Pete Houston


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à!
like image 29
Barmaley Avatar answered Feb 04 '26 19:02

Barmaley



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!