'How can I convert my Access Database (.accdb) to a SQLite database(.sqlite)?
How can I convert my Access Database (.accdb) to a SQLite database(.sqlite)?
Please, any help will be appreciated.
Solution 1:[1]
1) If you want to convert a structure of db you shoud use any DB-modeling tools:
- create new model from existing Access Database
- generate sql scripte for creating SQLite database
- use this script in SQL helper
2) If you want to import data from Access Database to your android app. I think you can do case #1, migrate all data from Access Database to temporary SQLite database, save it to asset folder and rewrite from asset to internal SQLite database during first app. start
Solution 2:[2]
May be you can use several step algoritm: 1. Export (convert) Access table or query to Excel file 2. Save Excel file as CSV file. 3. Use any SQLLite manager (for example, phpLiteAdmin) to import data from CSV file to exist SQLLite table.
Except Android and IOS, that use SQLLite, there are still webhostings, that use no more database engine, except for SQLLite.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Alex Klimashevsky |
| Solution 2 | Dmitry Bykov |