1

Are there any add-ons or something that can enable Microsoft Access to save its database as .sqlite?

Or do you know of any other way I can convert them, both ways.

Thanx a lot

Gillan
  • 149
  • 1
  • 4
  • 11
  • Unfortunately they are completely different, both the program language and the SQL syntax, even if you track down an app I feel this would be better to do manually. – Matt Donnan Apr 04 '12 at 08:00
  • 1
    this is pretty much duplicated i believe.. – nawfal Apr 04 '12 at 08:06
  • Please don't keep asking the same question: http://stackoverflow.com/questions/9924311/how-can-i-convert-my-access-database-accdb-to-a-sqlite-database-sqlite – Fionnuala Apr 04 '12 at 12:44
  • See also: http://stackoverflow.com/questions/7657115/how-to-convert-mdb-to-sqlite-database-in-android – Fionnuala Apr 04 '12 at 12:50

1 Answers1

0

If you can find an application (libreoffice?) or language with bindings/reader to access or if you can convert the access "db" into something sane, it shouldn't be too difficult to go to sqlite from there. The code you need will probably be specific to your particular database and not a universal Access->sqlite converter.

Actually, you might see if access could directly talk to sqlite over ODBC. Longshot, but that might be closest to a full answer to your question.

You could see these, for starters:

Community
  • 1
  • 1
XTL
  • 851
  • 1
  • 8
  • 23