Received: from bh.embare.ind.br (embint03.embare.com.br [200.251.240.3]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f0AHZYB44890 for ; Wed, 10 Jan 2001 12:35:35 -0500 (EST) (envelope-from cassio@planetarium.com.br) Received: (qmail 12939 invoked from network); 10 Jan 2001 17:36:02 -0000 Received: from micro23.bh.embare.com.br (HELO micro23) (192.168.5.23) by embbh01.bh.embare.com.br with SMTP; 10 Jan 2001 17:36:02 -0000 Message-ID: <008701c07b2b$b3260f40$1705a8c0@bh.embare.com.br> From: =?iso-8859-1?Q?C=E1ssio_Alexandre_Pereira_de_Castro?= To: References: <4.3.2.7.2.20010110091657.00b29a50@rccd.cc.ca.us> <006e01c07b29$d54ddfa0$1705a8c0@bh.embare.com.br> <3A5C9C0C.305E7DCE@joerdens.de> Subject: Re: Access to Pgsql Date: Wed, 10 Jan 2001 15:35:18 -0200 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4522.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 X-Archive-Number: 200101/29 X-Sequence-Number: 94 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" Cc: 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." > > 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 >