pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Access to Pgsql
5+ messages / 4 participants
[nested] [flat]

* Access to Pgsql
@ 2001-01-10 17:17 Julio Cuz, Jr. <jcuz@rccd.cc.ca.us>
  2001-01-10 17:21 ` Re: Access to Pgsql Cássio Alexandre Pereira de Castro <cassio@planetarium.com.br>
  0 siblings, 1 reply; 5+ messages in thread

From: Julio Cuz, Jr. @ 2001-01-10 17:17 UTC (permalink / raw)
  To: pgsql-php

Hi--

Is there a way to transfer or export data (tables) from MS Access 2000 to 
Postgresql (latest version)?  Any tutorials available?

Thanks!

Julio Cuz, Jr.
Riverside Community College
jcuz@rccd.cc.ca.us




^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Access to Pgsql
  2001-01-10 17:17 Access to Pgsql Julio Cuz, Jr. <jcuz@rccd.cc.ca.us>
@ 2001-01-10 17:21 ` Cássio Alexandre Pereira de Castro <cassio@planetarium.com.br>
  2001-01-10 17:29   ` Re: Access to Pgsql Frank Joerdens <frank@joerdens.de>
  0 siblings, 1 reply; 5+ messages in thread

From: Cássio Alexandre Pereira de Castro @ 2001-01-10 17:21 UTC (permalink / raw)
  To: pgsql-php

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?
>
> Thanks!
>
> Julio Cuz, Jr.
> Riverside Community College
> jcuz@rccd.cc.ca.us
>




^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Access to Pgsql
  2001-01-10 17:17 Access to Pgsql Julio Cuz, Jr. <jcuz@rccd.cc.ca.us>
  2001-01-10 17:21 ` Re: Access to Pgsql Cássio Alexandre Pereira de Castro <cassio@planetarium.com.br>
@ 2001-01-10 17:29   ` Frank Joerdens <frank@joerdens.de>
  2001-01-10 17:35     ` Re: Access to Pgsql Cássio Alexandre Pereira de Castro <cassio@planetarium.com.br>
  0 siblings, 1 reply; 5+ messages in thread

From: Frank Joerdens @ 2001-01-10 17:29 UTC (permalink / raw)
  To: ; +Cc: pgsql-php

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



^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Access to Pgsql
  2001-01-10 17:17 Access to Pgsql Julio Cuz, Jr. <jcuz@rccd.cc.ca.us>
  2001-01-10 17:21 ` Re: Access to Pgsql Cássio Alexandre Pereira de Castro <cassio@planetarium.com.br>
  2001-01-10 17:29   ` Re: Access to Pgsql Frank Joerdens <frank@joerdens.de>
@ 2001-01-10 17:35     ` Cássio Alexandre Pereira de Castro <cassio@planetarium.com.br>
  2001-01-10 18:38       ` Re: Access to Pgsql Adam Lang <aalang@rutgersinsurance.com>
  0 siblings, 1 reply; 5+ messages in thread

From: Cássio Alexandre Pereira de Castro @ 2001-01-10 17:35 UTC (permalink / raw)
  To: pgsql-php

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
>




^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Access to Pgsql
  2001-01-10 17:17 Access to Pgsql Julio Cuz, Jr. <jcuz@rccd.cc.ca.us>
  2001-01-10 17:21 ` Re: Access to Pgsql Cássio Alexandre Pereira de Castro <cassio@planetarium.com.br>
  2001-01-10 17:29   ` Re: Access to Pgsql Frank Joerdens <frank@joerdens.de>
  2001-01-10 17:35     ` Re: Access to Pgsql Cássio Alexandre Pereira de Castro <cassio@planetarium.com.br>
@ 2001-01-10 18:38       ` Adam Lang <aalang@rutgersinsurance.com>
  0 siblings, 0 replies; 5+ messages in thread

From: Adam Lang @ 2001-01-10 18:38 UTC (permalink / raw)
  To: pgsql-php

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
> >




^ permalink  raw  reply  [nested|flat] 5+ messages in thread


end of thread, other threads:[~2001-01-10 18:38 UTC | newest]

Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-01-10 17:17 Access to Pgsql Julio Cuz, Jr. <jcuz@rccd.cc.ca.us>
2001-01-10 17:21 ` Cássio Alexandre Pereira de Castro <cassio@planetarium.com.br>
2001-01-10 17:29   ` Frank Joerdens <frank@joerdens.de>
2001-01-10 17:35     ` Cássio Alexandre Pereira de Castro <cassio@planetarium.com.br>
2001-01-10 18:38       ` Adam Lang <aalang@rutgersinsurance.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox