From: Alex Young <alex@...>
Date: 2006-07-25T15:48:53+09:00
Subject: Re: Export Data from Microsoft Access database

M. Edward (Ed) Borasky wrote:
> 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.
> 
There is.  I've used Ruby-ODBC for extracting from Access to MySQL 
before.  Not in any particularly clever manner, mind you, but it works...

-- 
Alex