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).
Rutgers Casualty Insurance Company
----- Original Message -----
From: "Cássio Alexandre Pereira de Castro" <cassio(at)planetarium(dot)com(dot)br>
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....
> ----- Original Message -----
> From: "Frank Joerdens" <frank(at)joerdens(dot)de>
> Cc: <pgsql-php(at)postgresql(dot)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
> > > this data to your postgres tables!
> > >
> > > It works!
> > >
> > > Cassio.
> > >
> > > ----- Original Message -----
> > > From: "Julio Cuz, Jr." <jcuz(at)rccd(dot)cc(dot)ca(dot)us>
> > > To: <pgsql-php(at)postgresql(dot)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
> > > > Postgresql (latest version)? Any tutorials available?
> > You can also use the Postgres ODBC driver for Win32 to transfer the
> 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
> than the copy
> > method.
> > Regards, Frank
In response to
pgsql-php by date
|Next:||From: Julio Cuz, Jr.||Date: 2001-01-11 23:33:04|
|Subject: Access 2000 to PostgreSQL|
|Previous:||From: Cássio Alexandre Pereira de Castro||Date: 2001-01-10 17:35:18|
|Subject: Re: Access to Pgsql|