Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 970C42E005E for ; Wed, 26 Mar 2008 13:15:53 -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 83762-10 for ; Wed, 26 Mar 2008 13:15:47 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from ipmail01.adl6.internode.on.net (ipmail01.adl6.internode.on.net [203.16.214.146]) by postgresql.org (Postfix) with ESMTP id BE4D92E0049 for ; Wed, 26 Mar 2008 13:15:46 -0300 (ADT) X-IronPort-Anti-Spam-Filtered: true X-IronPort-Anti-Spam-Result: AuAEAM4Q6kfLevdH/2dsb2JhbACBWqlI X-IronPort-AV: E=Sophos;i="4.25,559,1199626200"; d="scan'208";a="69587353" Received: from ppp247-71.static.internode.on.net (HELO DevBox.local) ([203.122.247.71]) by ipmail01.adl6.internode.on.net with ESMTP; 27 Mar 2008 02:45:41 +1030 Message-ID: <47EA76AB.3010506@Sheeky.Biz> Date: Thu, 27 Mar 2008 02:45:39 +1030 From: Shane Ambler User-Agent: Thunderbird 2.0.0.12 (Macintosh/20080213) MIME-Version: 1.0 To: Shavonne Marietta Wijesinghe CC: pgsql-sql@postgresql.org Subject: Re: Export Access 97 to PostgreSQL References: <006101c88f2b$6d1cd170$3102a8c0@dream> <007301c88f2d$0e964ad0$3102a8c0@dream> <008e01c88f2f$63766ec0$3102a8c0@dream> <00b501c88f31$99b4edc0$3102a8c0@dream> <00cf01c88f33$1185e1f0$3102a8c0@dream> <002001c88f37$107363b0$3102a8c0@dream> In-Reply-To: <002001c88f37$107363b0$3102a8c0@dream> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/173 X-Sequence-Number: 30501 Shavonne Marietta Wijesinghe wrote: > Hello > > 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? csv would be the most common and easiest. Basically any structured text file can be used as you have the option of specifying what characters are used to separate fields etc when you import to postgresql. -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz