Importing Access 97 Database into 7.1.3

From: "Aaron Rouse" <pgsql(at)happyhacker(dot)com>
To: "PostgreSQL" <pgsql-general(at)postgresql(dot)org>
Subject: Importing Access 97 Database into 7.1.3
Date: 2001-10-25 02:57:34
Message-ID: 030301c15d00$cedfa130$0301a8c0@win2kpro
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kevin J. Drewiske 2001-10-25 03:21:33 Re: Using PostgreSQL and Access?
Previous Message Steven Vajdic 2001-10-25 02:31:33 Re: [GENERAL] Postgres 7.1.3. installation on Windows platfor