[cw-discuss] OBDC (Krsnendu dasa)

[Jeremy Tarrier]

Hello Krsnendu,

You may like to look at the following DevX article which covers the MySQL Migration Toolkit with a guided example and has links to the product pages.

To quote the article:

"The MySQL Migration Toolkit uses an eight-step process to ease the transition of data from a proprietary database (such as Microsoft Access, Microsoft SQL Server, or Oracle) to the MySQL open source database."


A Test Drive of the MySQL Migration Suite

If the embedded link above does not work via the mailing list, point your browser to:

http://www.devx.com/dbzone/Article/28553


Hope this helps,

Jeremy

discuss-request at crossover.codeweavers.com wrote:------------------------------

Message: 2
Date: Mon, 5 Feb 2007 08:36:14 +1300
From: "Krsnendu dasa" 
Subject: Re: [cw-discuss] OBDC
To: discuss at crossover.codeweavers.com
Message-ID:
 
Content-Type: text/plain; charset=ISO-8859-1; format=flowed

Thanks for your reply.

On 05/02/07, Brian C  wrote:
>
> If the ODBC code and the version of MS Access you are using are supported
> under CrossOver then you could probably eventually set that up.  How ever it
> would be MUCH easier, more reliable to export the data from Access and
> import it into a MySQL database.  Open Office has native support for MySQL
> and it can be installed on Linux and Windows.

Do you know of any guide for exporting from Access to MySQL?

>
> If that is not an option for some reason, the next best option would be to
> directly query the database via SQL instead of ODBC.  If Open Office can not
> do that you could set up batch files to the queries as need far easier that
> getting ODBC to work with Access though CrossOver

I don't quite get this part. Can you explain a bit more?

>
>
> On 2/3/07, Krsnendu dasa  wrote:
> >
> > Can the obdc drivers in CXL  be accessed by native linux
> > OpenOffice.org to allow access to MS Access files?
> >
> > Krsnendu dasa
> >
> > I think I accessdentally used access too many times in the sentence above.
> >
> > _______________________________________________
> > discuss mailing list
> > discuss at crossover.codeweavers.com
> > http://crossover.codeweavers.com/mailman/listinfo/discuss
> >
>
>
End of discuss Digest, Vol 21, Issue 5
**************************************




-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://crossover.codeweavers.com/pipermail/discuss/attachments/20070206/ec65c71c/attachment.htm