[cw-discuss] OBDC

[Michael Knepher]

On Mon, 2007-02-05 at 08:36 +1300, Krsnendu dasa wrote:
> Thanks for your reply.
> 
> On 05/02/07, Brian C <mrpronerd at gmail.com> 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?
> 

It looks like it hasn't been updated in a while, but MDB Tools
(http://mdbtools.sourceforge.net) is supposed to have tools for using
and exporting Access databases. It includes an ODBC driver for use with
unixODBC. You may be able to set up OpenOffice.org to hook into the
Access database using that. I'm not sure how stable it is, though. 

On the Windows side, I've used DBTools
(http://www.dbtools.com.br/EN/index.php) to export Access to MySQL. 

Then there's the manual way: recreate the structure of your database in
MySQL, export your tables from the Access db to csv files, and import
them into 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 <krsnendu108 at gmail.com> 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
> > >
> >
> >
> 
> _______________________________________________
> discuss mailing list
> discuss at crossover.codeweavers.com
> http://crossover.codeweavers.com/mailman/listinfo/discuss