Package mdbtools-0.6pre1-20080304-4

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.

Quick example using a NOAA dataset % wget 'http://chartmaker.ncd.noaa.gov/hsd/awois/\ contus/downloads/area1(mdb).zip' % unzip 'area1(mdb).zip' % mdb-ver section\ 1.mdb JET4 % mdb-tables section\ 1.mdb Section 1 % mdb-sql -H -p section\ 1.mdb % mdb-shema section\ 1.mdb % mdb-export -I section\ 1.mdb "Section 1" > commands.sql