CODEWITHSUNDEEP
sqlitems-access
Gillan
Gillan

Reputation: 159

How can I convert my Access database (.accdb) to SQLite?

How can I convert my Access database (.accdb) to an SQLite database(.sqlite)?

Upvotes: 4

Views: 18804

Answers (3)

Jaffer Al-Delphi
Jaffer Al-Delphi

Reputation: 1

Check this link out, Migrating data from MS Access(*.mdb; *.accdb) to SQLite and other SQL types

You'll need to install Access Database Engine befor doing so Microsoft Access Database Engine 2016 Redistributable. if you got error installing the Access Database Engine like the attached image, then just use cmd to install it, as follow:

  1. open cmd, and navigate to folder dir that has the .exe file.
  2. And run AccessDatabaseEngine.exe /quiet to install it.

enter image description here

Upvotes: 0

Dmitry Bykov
Dmitry Bykov

Reputation: 11

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.

Upvotes: 1

Alex Klimashevsky
Alex Klimashevsky

Reputation: 2495

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

Upvotes: 0

Related Questions