March 17th, 2001, 05:05 PM
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.
International Job Links
March 24th, 2001, 03:45 PM
Use some of the mySQL tools
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
November 5th, 2001, 01:28 PM
export from Access into Postgresql
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.