*: {link: http://mdbtools.sourceforge.net/ MDB Tools}

_: The MDB Tools project is a effort to document the MDB file format used in Microsoft's Access database package, and to provide a set of tools and applications to make that data available on other platforms. 

_:Specifically, MDB Tools includes programs to export schema and data to other databases such as MySQL, Oracle, Sybase, PostgreSQL, and others. 

_:Also, included is a SQL engine for performing simple SQL queries. The 0.5 release includes an updated GUI interface (screenshot is available here). A sparse but functional ODBC driver is included as well. 

_:MDB Tools currently has read-only support for Access 97 (Jet 3) and Access 2000/2002 (Jet 4) formats. Access 2000 support is a recent addition and may not be as complete as Jet 3 support. 

_:Write support is currently being worked on and the first cut is expected to be included in the 0.6 release.

_:*Note:* I don't think it supports SQLite right now, but this project can be continued and used for that purpose.

*: Simple VB MDB to SQLite

_: I coded up a small limited visual basic tool that takes in an MDB and produces a text file that can be piped into the sqlite command line tool to create a database.  It's simple and very dirty code, but it does work for simple databases.  It's attached to this document and you can do whatever you want with it.

_: i did a few improvements to vb mdbtosqlite to convert northwind, orders, biblio, and gallery ms-access sample mdbs to sql code loadable in sqlite.
everything was read fine, with the exception of binary picture fields, which are also been reported in the output file, as comments closely following each create table statement. the ofending fields are still being created with "BINARY" type and inserted as NULL. code is posted as mdbtosqlite2.zip, so that the original author might examine it and hopefully merge the two versions.

_: <rapto@arrakis.es> I have modified this program into a vbs so you don't have to have Visual Basic.

_: <rotoxl@jazzfree.com> Changed function getSQLiteFieldType according to dao360 docs to handle datatypes properly.

_: <rotoxl@jazzfree.com> the link: http://burke.ath.cx/~ernesto/MDBtoSQLite.vbs


*: {link: http://sqlfairy.sourceforge.net/ SQLFairy or SQL::Translator}

From their website:

_: SQL::Translator is a group of Perl modules that manipulate structure data definitions (mostly database schemas) in interesting ways, such as converting among different dialects of CREATE syntax (e.g., MySQL-to-Oracle), visualizations of schemas (pseudo-ER diagrams GraphViz or GD), automatic code generation (using Class::DBI), converting non-RDBMS files to SQL schemas (xSV text files, Excel spreadsheets), serializing parsed schemas (via Storable, YAML and XML), creating documentation (HTML and POD), and more. New to version 0.03 is the ability to talk directly to a database through DBI to query for the structures of several databases. 

_: Excellent tool which helped me migrate from MySQL to SQLite.

*: {link: http://www.rosa.nl/ Firebird <-> SQLite}

_: Windows executable with sources