From: "M. Edward (Ed) Borasky" <znmeb@...>
Date: 2006-07-25T10:43:13+09:00
Subject: Re: Export Data from Microsoft Access database

Jatinder Singh wrote:
> Can I use mdbtools on Windows platform?  the reason I am asking this 
> is bcos
> I do not seem to get installation/configuration info of mdbtools info for
> Windows platform.
> Am I missing something here? could you please assist me if you have 
> any info
> on the same.
>
> Regards,
> Jatinder
>
>
> On 7/24/06, snacktime <snacktime@gmail.com> wrote:
>>
>> On 7/24/06, Jatinder Singh <jatinder.saundh@gmail.com> 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
>> >
>>
>> Not ruby, but there is a collection of great little command line tools
>> for exporting access databases.    http://mdbtools.sourceforge.net/.
>>
>>
>
If they're open source, they might be compilable/executable in CygWin. 
But on a Windows system, you can probably do what you want using ODBC. 
Just create a dataset name pointing to you MDB file and issue ODBC 
queries. You might need some other Microsoft query utilities and you 
might have to construct SQL in your Ruby code; I don't use Ruby on 
Windows so I don't know if there's an ODBC connection capability in Ruby.