Received: from rakete.joerdens.de (rakete.joerdens.de [62.104.116.200]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f0AHTZB44272 for ; Wed, 10 Jan 2001 12:29:35 -0500 (EST) (envelope-from frank@joerdens.de) Received: from limedes.archi-me-des.de (pD9502007.dip.t-dialin.net [217.80.32.7]) by rakete.joerdens.de (8.9.3/8.9.3) with ESMTP id SAA16581 for ; Wed, 10 Jan 2001 18:53:21 +0100 Received: from joerdens.de (tricky.archi-me-des.de [192.168.100.1]) by limedes.archi-me-des.de (8.9.3/8.9.3) with ESMTP id SAA32566 for ; Wed, 10 Jan 2001 18:13:08 +0100 Message-ID: <3A5C9C0C.305E7DCE@joerdens.de> Date: Wed, 10 Jan 2001 18:29:48 +0100 From: Frank Joerdens X-Mailer: Mozilla 4.72 [en] (WinNT; I) X-Accept-Language: en MIME-Version: 1.0 CC: pgsql-php@postgresql.org Subject: Re: Access to Pgsql References: <4.3.2.7.2.20010110091657.00b29a50@rccd.cc.ca.us> <006e01c07b29$d54ddfa0$1705a8c0@bh.embare.com.br> Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Archive-Number: 200101/28 X-Sequence-Number: 93 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." > To: > 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