From MS Access to PostgreSQL

Hello!
I have got a Microsoft Access database and I want to convert it into PostgreSQL.
Is there any free software to do that?
If not, can anybody explain me step by step (I am not an expert) how to do it, please?
Any other suggestion (useful resources or links) are welcome.

Fabio
International Job Links
URL

One thought is that you could use any of a few utils that will take MS Access database and via a macro produce a text file containing the SQL statements required to recreate that database.

I've seen these tools on the www.mysql.com website. They're meant for mysql but should work just as well with any database that can accept SQL.

Or get Access to export a CSV (comma separated values - ask your Office Assistant) file and import that into your web database (again, I don't know what tools you'd use to do that - mysql would be mysqlimport).

Hope that helps

-Adz

Get a copy of the PostgreSQL odbc driver from odbc.postgresql.com and install it. Then create a ODBC DSN in the control panel



when it works, open up your Access database, go to /File/Export.
Change the database type to ODBC databases and click on the PostgreSQL DSN you created.