You have to use Access to export into PGSQL 7.1.3, after defining an ODBC
alias. So you can import, export and have links with PGSQL.
Michel BELLON
LCIE - Informatique appliquée
33 (0)1 40 95 60 35
> -----Message d'origine-----
> De: Aaron Rouse [SMTP:pgsql@happyhacker.com]
> Date: jeudi 25 octobre 2001 04:58
> À: PostgreSQL
> Objet: [GENERAL] Importing Access 97 Database into 7.1.3
>
> I have the need to import an Access 97 database into PGSQL 7.1.3 It
> has
> been a long time since I had to do this and back when I did, I just used
> the
> PGAdmin tool which worked fine at the time with the exception of not
> converting AutoNumber data types to Serial, but to Int datatypes. I do
> not
> see a way to import Access DBs with the new PGAdmin II tool and so far the
> only way I am finding to import the database is to import each table one
> by
> one via a ODBC connection and the export feature in Access. This method
> still gives the same problem with the Autonumber datatype being converted
> to
> Int and I am assuming it leaves out any indexes or default values as well.
> Is there another way to import this database that I might be missing?
>
> Thanks for any help.
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
