Convert Database From MSAccess to SQlite for android

android sqlite ms-access

you can convert it using following tools:

https://www.sqlite.org/cvstrac/wiki?p=ConverterTools

http://mdb2sq3.codeplex.com/

http://www.basic4ppc.com/forum/code-samples-tips/78-how-convert-access-database-sqlite-database.html

android sqlite ms-access

if your database contains forty tables with eighty relationships, constrainsyou can try to use:https://github.com/arturasn/mdb2sqlite

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

android sqlite ms-access

I have done this way:

Export Database from MSAccess as a Text File
Save this text file to your local hard disk
Open SQLite data browser
Create new Database
Import saved text file as Import Table From CSV File
Create table for database
Save database

Done