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