From: Jatinder Singh <jatinder.saundh@...>
Date: 2006-07-25T00:04:54+09:00
Subject: Re: Export Data from Microsoft Access database

------=_Part_152869_22736748.1153753488920
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Leslie,

I came across your findings.
I am wondering if this(migration of all access tables including
relationships and data) has been achieved in other languages as well like
Java,VBA, etc. and is still to be achieved in Ruby.
I am looking at some library which could help me with mapping of datatypes
and differences between Access and Oracle/DB2; I can do it from scratch but
that would be my last option.



Regards,
Jatinder

On 7/24/06, Leslie Viljoen <leslieviljoen@gmail.com> wrote:
>
> On 7/24/06, M. Edward (Ed) Borasky <znmeb@cesmail.net> wrote:
> > 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.
>
> I did some work using Ruby and Access. I wrote some of my findings on
> RubyGarden:
> http://wiki.rubygarden.org/Ruby/page/show/ScriptingAccess
>
> Les
>
>

------=_Part_152869_22736748.1153753488920--