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.
