Copy is quickest/dirtiest way.
but as the other person mentioned, you can code to do it also. Either make
an Access module that copies data over or make a separate application that
reads the access tables and copies itover.
You'll get a lot more help on this on the postgresql interfaces list. I'm
sure the vast majority of the people on this list use PHP, not access (as
the list name reflects).
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
http://www.rutgersinsurance.com
----- Original Message -----
From: "Cássio Alexandre Pereira de Castro" <cassio@planetarium.com.br>
To: <pgsql-php@postgresql.org>
Sent: Wednesday, January 10, 2001 12:35 PM
Subject: Re: [PHP] Access to Pgsql
> I´ve transferred the data from a Windows machine to a Linux machine and I
> didn´t figure out an eaiser way to do it....
>
> Thanks,
>
> Cassio
> ----- Original Message -----
> From: "Frank Joerdens" <frank@joerdens.de>
> Cc: <pgsql-php@postgresql.org>
> Sent: Wednesday, January 10, 2001 3:29 PM
> Subject: Re: [PHP] Access to Pgsql
>
>
> > Cássio Alexandre Pereira de Castro wrote:
> > >
> > > You must export your data table to text files and use copy command to
> import
> > > this data to your postgres tables!
> > >
> > > It works!
> > >
> > > Cassio.
> > >
> > > ----- Original Message -----
> > > From: "Julio Cuz, Jr." <jcuz@rccd.cc.ca.us>
> > > To: <pgsql-php@postgresql.org>
> > > Sent: Wednesday, January 10, 2001 3:17 PM
> > > Subject: [PHP] Access to Pgsql
> > >
> > > > Hi--
> > > >
> > > > Is there a way to transfer or export data (tables) from MS Access
2000
> to
> > > > Postgresql (latest version)? Any tutorials available?
> >
> > You can also use the Postgres ODBC driver for Win32 to transfer the
data.
> Last time I
> > checked, the ODBC driver did only support versions up to 6.5. Dunno
> whether that's been
> > fixed but I guess it'd be worth a try. It's considerably more
comfortable
> than the copy
> > method.
> >
> > Regards, Frank
> >