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.
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 |