Page 1 of 1

Exporting Base database (*odb) to MSAccess (*mdb)

Posted: Wed Apr 02, 2008 5:32 pm
by joaofresende
Hi,

I use a GIS (geographic information system) that only read databases in these formats:
Access, SQLServer, OracleADO, MySQL e PostgreSQL

But the only database tool I have in my PC is OpenOffice Base (I have the entire suite: Calc, Writer etc...). I don´t have MSAccess or other tools installed...

How could I convert databases in *odb format in any of these formats above, preferably in MSAccess (*mdb)?

Very thanks!

OpenOffice 2.0/ WinXP Professional SP2

Re: Exporting Base database (*odb) to MSAccess (*mdb)

Posted: Thu Apr 10, 2008 7:51 pm
by r4zoli
I think, using mdb is not a best way, but require some effort and learning. You could install MySQL on your machine, and use Base as frontend to MySQL. Then you copy your databases from Base own format to MySQL, and dump out that, and after that MySQL dump import into your GIS.