#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2001
    Posts
    1
    Rep Power
    0

    Question


    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
    http://www.joblinks.f2s.com/index_eng.htm
  2. #2
  3. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2000
    Location
    Manchester
    Posts
    16
    Rep Power
    0

    Post 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

    -Adz
  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2000
    Location
    I'm in New England
    Posts
    4
    Rep Power
    0

    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.

IMN logo majestic logo threadwatch logo seochat tools logo