• Registered: 2014-04-19
  • Posts: 19

Topic: Convert Data Base MS Access .MDB to SQLite .DB

Greetings to the MVDB Team

A question, if I have a project in MS Access .MDB, how do I convert this database to SQLite?

Preferably Open Source for Windows 7

Thank you for your usual prompt response and attention.

  • Registered: 2014-02-14
  • Posts: 10,294

Re: Convert Data Base MS Access .MDB to SQLite .DB

Hello,

First you need make export from .MDB to CSV file:
http://social.msdn.microsoft.com/Forums … rum=isvvba

After you can use free tool SQLiteStudio for import to SQLite.


But usually is not easy, may be many nuances

Dmitry.
  • Registered: 2014-04-19
  • Posts: 19

Re: Convert Data Base MS Access .MDB to SQLite .DB

Thanks Team

if that option i know, what I want to do is save the time of return to define the basis of data in SQLite.

If you know of any open source software, which perform the work to convert the MS Access database to SQLite, you thank you

  • Registered: 2014-02-14
  • Posts: 10,294

Re: Convert Data Base MS Access .MDB to SQLite .DB

Unfortunately I was unable to find a free program to do this.

Dmitry.