From: "M. Edward (Ed) Borasky" <znmeb@...>
Date: 2006-07-24T22:33:38+09:00
Subject: Re: Export Data from Microsoft Access database

Jatinder Singh wrote:
> How could I leverage Ruby to export mdb tables definations, data, forms,
> queries and then be able to import it in to some other dbms like 
> oracle/db2
> etc?
>
> Regards,
> Jatinder
>
On WIndows, there is ODBC, of course, and there's an "Access engine" 
that has part of the functionality of the real thing. If you have an 
Access license, there's OLE/DCOM.

On Linux, try unixODBC or mdbtools 
(http://sourceforge.net/projects/mdbtools/). I'm not sure if any of 
these (other than OLE/DCOM) are accessible directly from Ruby yet.