Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 2F93C2E005F for ; Thu, 27 Mar 2008 09:41:56 -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 75975-10 for ; Thu, 27 Mar 2008 09:41:46 -0300 (ADT) X-Greylist: delayed 00:24:54.398801 by SQLgrey-1.7.5 Received: from dfbsa63.conab.gov.br (dfbsa63.conab.gov.br [200.140.131.205]) by postgresql.org (Postfix) with ESMTP id 742942E0083 for ; Thu, 27 Mar 2008 09:41:46 -0300 (ADT) Received: from [10.131.1.6] (RSSEDEM2.conab.gov.br [10.131.1.6]) by dfbsa63.conab.gov.br (Postfix) with ESMTP id 4EC7B940F7; Thu, 27 Mar 2008 09:16:43 -0300 (BRT) Message-ID: <47EB9024.4030305@conab.gov.br> Date: Thu, 27 Mar 2008 09:16:36 -0300 From: Roberto Spier User-Agent: Thunderbird 2.0.0.12 (Windows/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-Spam-Status: No, hits=0.303 tagged_above=0 required=5 tests=AWL=0.303 X-Spam-Level: X-Archive-Number: 200803/198 X-Sequence-Number: 30526 Shavonne Marietta Wijesinghe escreveu: > 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? > > Thanks > > Shavonne Export the data, instead! You'd connect (link) to the postgreSQL database from within access mdb, then run an acc's INSERT INTO query. hth -- Spier