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

[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

[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.