MDB Tools

source: http://mdbtools.sourceforge.net/

---

What is 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. Write support is currently being worked on and the first cut is expected to be included in the 0.6 release.
For more information check our FAQ and our Installation Guide. Also see our SourceForge Page for forums, bugtracking, CVS, et al.

Getting MDB Tools?

Source code for MDB Tools is available from CVS at sourceforge. To anon cvs it, do like this (there is no password, so just hit Enter when asked):

cvs -d:pserver:anonymous@mdbtools.cvs.sourceforge.net:/cvsroot/mdbtools login
cvs -z3 -d:pserver:anonymous@mdbtools.cvs.sourceforge.net:/cvsroot/mdbtools co mdbtools

Alternatively, you can obtain the 0.5 release or the 0.6pre1 release. And 0.5 RPMs for i386 Linux are available here.

Mailing List

There is a mailing list for those having trouble or who are interested in helping or tracking MDB Tools progress. To subscribe go to http://lists.sourceforge.net/mailman/listinfo/mdbtools-dev

Resources

Here are some resources that may be useful with MDB Tools (Note: Microsoft reorganized and removed some of these, so they are left as an aid to tracking down the new locations, if any).
MSDN

when this page opens, on the left side, click on books, then microsoft jet database engine programmers guide. There are 13 chapters & 5 appendices.

Here's a couple of links that talk about the size of some of the objects:

sudo apt-get install mdbtools

ODBC

In order to use ODBC you must place an entry in the odbc.ini file.

Example 6-1. odbc.ini file

[Northwind]
Description = Northwind Sample Database
Driver = /usr/local/lib/libmdbodbc.so
Database = /data/mdbfiles/Northwind.mdb

Consult the unixODBC documentation for full details.