pg.ddx.io pgsql-php@postgresql.org mailing list archive
help / color / mirror / Atom feedAccess 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