Re: Importing Access 97 Database into 7.1.3

How can I import from access to pgsql?, import, not export...

I can export very well, but can I import?



Saludos,

Basil Briceno
~~~~~~~~~~~~~
bbh@wdev.org
icq 42077316
+52 81942180
~~~~~~~~~~~~~
"Man is free at the moment he wishes to be".
--Voltaire

On Thu, 25 Oct 2001, BELLON Michel wrote:

> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>