Re: Importing Access 97 Database into 7.1.3

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