Geek asks and answers

How to convert MDB to SQLite in Android

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

How to convert .mdb database to SQLite?

+3
source share
4 answers

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

  • Install SQlite on your desktop - just go to sqlite.org
  • Get JDBC access to SQLite (there are many JDBC drivers for SQLite)
  • Access JDBC to your MDB (MS-Access) using JDBC (regular JDBC-ODBC bridge driver is OK)
  • Voila!
+1
source

android:

1-Creat Acces Database, , . 2- SQLite 1.1 (http://sourceforge.net/projects/sqlitebrowser/files/sqlitebrowser/1.1/sqlitebrowser-1.1-win.zip/download?use_mirror=garr&download=) DATABASE, , → import- > csv. . "". 3-.

, Android, .

1) "android_metadata" 2) "locale" 3) "en_US" 4) "_id" ( , Android , id ) .

: SQLite Android: http://www.reigndesign.com/blog/using-your-own-sqlite-database-in-android-applications/

0

Another great tool to convert .mdb database to SQLite: https://github.com/arturasn/mdb2sqlite

Executable direct download: https://github.com/arturasn/mdb2sqlite/blob/master/bin/mdb2sqlite.exe

0
source

More articles:


All Articles