Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 057C62E0062 for ; Wed, 26 Mar 2008 08:46:55 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 84952-10 for ; Wed, 26 Mar 2008 08:46:52 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from smtpout09.attiva.biz (smtpout09.attiva.biz [85.37.16.7]) by postgresql.org (Postfix) with ESMTP id 340AF2E0031 for ; Wed, 26 Mar 2008 08:46:51 -0300 (ADT) Received: from FBCMFE02B14.fbc.local ([192.168.30.160]) by smtpout09.attiva.biz with Microsoft SMTPSVC(6.0.3790.1830); Wed, 26 Mar 2008 12:46:43 +0100 Received: from dream ([88.34.161.130]) by FBCMFE02B14.fbc.local with Microsoft SMTPSVC(6.0.3790.1830); Wed, 26 Mar 2008 12:46:43 +0100 Message-ID: <002001c88f37$107363b0$3102a8c0@dream> Reply-To: "Shavonne Marietta Wijesinghe" From: "Shavonne Marietta Wijesinghe" To: References: <006101c88f2b$6d1cd170$3102a8c0@dream> <007301c88f2d$0e964ad0$3102a8c0@dream> <008e01c88f2f$63766ec0$3102a8c0@dream> <00b501c88f31$99b4edc0$3102a8c0@dream> <00cf01c88f33$1185e1f0$3102a8c0@dream> Subject: Export Access 97 to PostgreSQL Date: Wed, 26 Mar 2008 12:46:43 +0100 Organization: Studio FORM MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_001D_01C88F3F.71CA15C0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.3138 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198 X-OriginalArrivalTime: 26 Mar 2008 11:46:43.0695 (UTC) FILETIME=[1025DFF0:01C88F37] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/170 X-Sequence-Number: 30498 This is a multi-part message in MIME format. ------=_NextPart_000_001D_01C88F3F.71CA15C0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello=20 I have a db in MS Access 97 and now i have to import the data in = PostgreSQL. I can create the table structure in PostgreSql but in what = format can i export the table from Access so Postgresql can read it? Thanks Shavonne ------=_NextPart_000_001D_01C88F3F.71CA15C0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Hello

I have a db in MS Access 97 and now i have to import the=20 data in PostgreSQL. I can create the table structure in PostgreSql = but in=20 what format can i export the table from Access so Postgresql can read = it?

Thanks

Shavonne

------=_NextPart_000_001D_01C88F3F.71CA15C0--