Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 5311B2E004A for ; Thu, 27 Mar 2008 06:04:14 -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 60004-04 for ; Thu, 27 Mar 2008 06:04:10 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from smtpout26.attiva.biz (smtpout26.attiva.biz [85.37.16.27]) by postgresql.org (Postfix) with ESMTP id C7BF32E0065 for ; Thu, 27 Mar 2008 06:04:09 -0300 (ADT) Received: from FBCMFE02B06.fbc.local ([192.168.30.94]) by smtpout26.attiva.biz with Microsoft SMTPSVC(6.0.3790.1830); Thu, 27 Mar 2008 10:04:03 +0100 Received: from DREAM ([88.34.161.130]) by FBCMFE02B06.fbc.local with Microsoft SMTPSVC(6.0.3790.1830); Thu, 27 Mar 2008 10:03:55 +0100 Message-ID: <004a01c88fe9$7dc58df0$0602a8c0@DREAM> Reply-To: "Shavonne Marietta Wijesinghe" From: "Shavonne Marietta Wijesinghe" To: "Shawn" , References: <002001c88f37$107363b0$3102a8c0@dream> <200803261621.55622.postgres@xmtservices.net> Subject: Re: Export Access 97 to PostgreSQL Date: Thu, 27 Mar 2008 10:03:57 +0100 Organization: Studio FORM MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original Content-Transfer-Encoding: 7bit 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: 27 Mar 2008 09:03:56.0053 (UTC) FILETIME=[7C97BC50:01C88FE9] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/193 X-Sequence-Number: 30521 Thanks. I tried the following command COPY REGIONI FROM 'C:/Inetpub/wwwroot2/FORMWebSite1/database/FormAjax/REGIONI.copy' WITH DELIMITER '\t'; But i get this error ERROR: relation "regioni" does not exist Here is a sample of my file (fields seperated with a tab) 13600770000,00 848351,00 2,00 2,00 4,00 "Trentino-alto adige" 18424000000,00 1132202,00 3,00 3,00 5,00 "Veneto" 7859928000,00 746082,90 4,00 4,00 6,00 "Friuli-venezia giulia" What can the problem be? Shavonne