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(at)wdev(dot)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 applique
> 33 (0)1 40 95 60 35
>
> > -----Message d'origine-----
> > De: Aaron Rouse [SMTP:pgsql(at)happyhacker(dot)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(at)postgresql(dot)org so that your
> > message can get through to the mailing list cleanly
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>