From shavonne.marietta@studioform.it Wed Mar  26 11:46:55 2008
Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 057C62E0062
	for <pgsql-sql-postgresql.org@postgresql.org>;
	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 <pgsql-sql-postgresql.org@postgresql.org>;
	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 <pgsql-sql@postgresql.org>; 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" <shavonne.marietta@studioform.it>
From: "Shavonne Marietta Wijesinghe" <shavonne.marietta@studioform.it>
To: <pgsql-sql@postgresql.org>
References: <F73B183585950041A3B8A59178A1FEE45D4656@WDF-MX05.de.realTech.net>
	<006101c88f2b$6d1cd170$3102a8c0@dream>
	<F73B183585950041A3B8A59178A1FEE45D4657@WDF-MX05.de.realTech.net>
	<007301c88f2d$0e964ad0$3102a8c0@dream>
	<F73B183585950041A3B8A59178A1FEE45D4658@WDF-MX05.de.realTech.net>
	<008e01c88f2f$63766ec0$3102a8c0@dream>
	<F73B183585950041A3B8A59178A1FEE45D465A@WDF-MX05.de.realTech.net>
	<00b501c88f31$99b4edc0$3102a8c0@dream>
	<F73B183585950041A3B8A59178A1FEE47FF68B@WDF-MX05.de.realTech.net>
	<00cf01c88f33$1185e1f0$3102a8c0@dream>
	<F73B183585950041A3B8A59178A1FEE47FF68D@WDF-MX05.de.realTech.net>
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

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML dir=3Dltr><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.6000.16608" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>
<DIV>Hello </DIV>
<DIV>&nbsp;</DIV>
<DIV>I have a&nbsp;db in MS Access 97 and now i have to&nbsp;import the=20
data&nbsp;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?</DIV>
<DIV>&nbsp;</DIV>
<DIV>Thanks</DIV>
<DIV>&nbsp;</DIV>
<DIV>Shavonne</DIV></FONT></DIV></BODY></HTML>

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




From pgsql@Sheeky.Biz Wed Mar  26 16:15:53 2008
Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 970C42E005E
	for <pgsql-sql-postgresql.org@postgresql.org>;
	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 <pgsql-sql-postgresql.org@postgresql.org>;
	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 <pgsql-sql@postgresql.org>; 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 <pgsql@Sheeky.Biz>
User-Agent: Thunderbird 2.0.0.12 (Macintosh/20080213)
MIME-Version: 1.0
To: Shavonne Marietta Wijesinghe <shavonne.marietta@studioform.it>
CC: pgsql-sql@postgresql.org
Subject: Re: Export Access 97 to PostgreSQL
References: <F73B183585950041A3B8A59178A1FEE45D4656@WDF-MX05.de.realTech.net>
	<006101c88f2b$6d1cd170$3102a8c0@dream>
	<F73B183585950041A3B8A59178A1FEE45D4657@WDF-MX05.de.realTech.net>
	<007301c88f2d$0e964ad0$3102a8c0@dream>
	<F73B183585950041A3B8A59178A1FEE45D4658@WDF-MX05.de.realTech.net>
	<008e01c88f2f$63766ec0$3102a8c0@dream>
	<F73B183585950041A3B8A59178A1FEE45D465A@WDF-MX05.de.realTech.net>
	<00b501c88f31$99b4edc0$3102a8c0@dream>
	<F73B183585950041A3B8A59178A1FEE47FF68B@WDF-MX05.de.realTech.net>
	<00cf01c88f33$1185e1f0$3102a8c0@dream>
	<F73B183585950041A3B8A59178A1FEE47FF68D@WDF-MX05.de.realTech.net>
	<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



From postgres@xmtservices.net Wed Mar  26 16:22:06 2008
Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 7F2D92E005E
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Wed, 26 Mar 2008 13:22:06 -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 86355-06 for <pgsql-sql-postgresql.org@postgresql.org>;
	Wed, 26 Mar 2008 13:21:57 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.5
Received: from mail.xmtservices.net (unknown [66.224.65.210])
	by postgresql.org (Postfix) with SMTP id 75F5E2E0060
	for <pgsql-sql@postgresql.org>; Wed, 26 Mar 2008 13:21:57 -0300 (ADT)
Received: (qmail 2712 invoked from network); 26 Mar 2008 16:21:56 -0000
Received: from unknown (HELO vaio.xmtservices.net) (192.168.0.101)
	by errol.xmtservices.net with SMTP; 26 Mar 2008 16:21:56 -0000
From: Shawn <postgres@xmtservices.net>
To: pgsql-sql@postgresql.org
Subject: Re: Export Access 97 to PostgreSQL
Date: Wed, 26 Mar 2008 16:21:55 +0000
User-Agent: KMail/1.9.9
References: <F73B183585950041A3B8A59178A1FEE45D4656@WDF-MX05.de.realTech.net>
	<F73B183585950041A3B8A59178A1FEE47FF68D@WDF-MX05.de.realTech.net>
	<002001c88f37$107363b0$3102a8c0@dream>
In-Reply-To: <002001c88f37$107363b0$3102a8c0@dream>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200803261621.55622.postgres@xmtservices.net>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200803/174
X-Sequence-Number: 30502

On Wednesday 26 March 2008 11:46:43 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?
>
> Thanks
>
> Shavonne

Hello Shavonne,

I'm no expert but I have often used either the tab or comma delimited format.  
It requires that the fields in the PostgreSQL table are in the same order as 
the original and that the data types are formatted similarly, but it has 
worked for me.  Also a sed and awk'ing of the results can clean up alot of 
formatting issues.

example, one of my fields is in the timestamp with time zone format but MS-SQL 
doesn't differentiate Time Zones, at least not in the database I'm pulling 
from.  I use this line to add the UTC to the field " sed 's/\t/ UTC\t/1'".

Shawn 




From shavonne.marietta@studioform.it Thu Mar  27 09:04:14 2008
Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 5311B2E004A
	for <pgsql-sql-postgresql.org@postgresql.org>;
	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 <pgsql-sql-postgresql.org@postgresql.org>;
	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 <pgsql-sql@postgresql.org>; 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" <shavonne.marietta@studioform.it>
From: "Shavonne Marietta Wijesinghe" <shavonne.marietta@studioform.it>
To: "Shawn" <postgres@xmtservices.net>,
	<pgsql-sql@postgresql.org>
References: <F73B183585950041A3B8A59178A1FEE45D4656@WDF-MX05.de.realTech.net>
	<F73B183585950041A3B8A59178A1FEE47FF68D@WDF-MX05.de.realTech.net>
	<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 




From mail@webthatworks.it Thu Mar  27 09:55:01 2008
Received: from localhost (unknown [200.46.204.184])
	by postgresql.org (Postfix) with ESMTP id 808262E005F
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Thu, 27 Mar 2008 06:55:01 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024)
	with ESMTP id 57982-02 for <pgsql-sql-postgresql.org@postgresql.org>;
	Thu, 27 Mar 2008 06:54:37 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.5
Received: from vsmtp12.tin.it (vsmtp12.tin.it [212.216.176.206])
	by postgresql.org (Postfix) with ESMTP id 503862E0059
	for <pgsql-sql@postgresql.org>; Thu, 27 Mar 2008 06:54:41 -0300 (ADT)
Received: from kerberos.webthatworks.it (79.0.131.251) by vsmtp12.tin.it
	(7.3.122) id 47BC9482024522BB; Thu, 27 Mar 2008 10:54:39 +0100
Received: from stige.webthatworks.it (odark.webthatworks.it [192.168.1.72])
	by kerberos.webthatworks.it (Postfix) with ESMTP id F09D1E6A96;
	Thu, 27 Mar 2008 10:54:38 +0100 (CET)
Received: from localhost (localhost [127.0.0.1])
	by stige.webthatworks.it (Postfix) with ESMTP id 475B39B162;
	Thu, 27 Mar 2008 10:54:37 +0100 (CET)
Date: Thu, 27 Mar 2008 10:54:36 +0100
From: Ivan Sergio Borgonovo <mail@webthatworks.it>
To: pgsql-sql@postgresql.org
Cc: "Shavonne Marietta Wijesinghe" <shavonne.marietta@studioform.it>
Subject: Re: Export Access 97 to PostgreSQL
Message-ID: <20080327105436.36e13506@webthatworks.it>
In-Reply-To: <004a01c88fe9$7dc58df0$0602a8c0@DREAM>
References: <F73B183585950041A3B8A59178A1FEE45D4656@WDF-MX05.de.realTech.net>
	<F73B183585950041A3B8A59178A1FEE47FF68D@WDF-MX05.de.realTech.net>
	<002001c88f37$107363b0$3102a8c0@dream>
	<200803261621.55622.postgres@xmtservices.net>
	<004a01c88fe9$7dc58df0$0602a8c0@DREAM>
Organization: www.WebThatWorks.it
X-Mailer: Claws Mail 3.3.1 (GTK+ 2.12.9; x86_64-pc-linux-gnu)
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200803/194
X-Sequence-Number: 30522

On Thu, 27 Mar 2008 10:03:57 +0100
"Shavonne Marietta Wijesinghe" <shavonne.marietta@studioform.it>
wrote:

> 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

You've to create the REGIONI table.
You may (or may not) get into trouble with locale. I noticed you're
using , as a decimal separator.
So if you're still encountering problems... that could be the second
thing to look at.

> 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"

-- 
Ivan Sergio Borgonovo
http://www.webthatworks.it




From shavonne.marietta@studioform.it Thu Mar  27 10:06:53 2008
Received: from localhost (unknown [200.46.204.184])
	by postgresql.org (Postfix) with ESMTP id 06A322E0031
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Thu, 27 Mar 2008 07:06:53 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024)
	with ESMTP id 60855-06 for <pgsql-sql-postgresql.org@postgresql.org>;
	Thu, 27 Mar 2008 07:06:39 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.5
Received: from smtpout18.attiva.biz (smtpout18.attiva.biz [85.37.16.20])
	by postgresql.org (Postfix) with ESMTP id A51FA2E0059
	for <pgsql-sql@postgresql.org>; Thu, 27 Mar 2008 07:06:44 -0300 (ADT)
Received: from FBCMFE02B14.fbc.local ([192.168.30.160]) by
	smtpout18.attiva.biz with Microsoft SMTPSVC(6.0.3790.1830);
	Thu, 27 Mar 2008 11:06:41 +0100
Received: from DREAM ([88.34.161.130]) by FBCMFE02B14.fbc.local with Microsoft
	SMTPSVC(6.0.3790.1830); Thu, 27 Mar 2008 11:06:38 +0100
Message-ID: <007201c88ff2$404ffa60$0602a8c0@DREAM>
Reply-To: "Shavonne Marietta Wijesinghe" <shavonne.marietta@studioform.it>
From: "Shavonne Marietta Wijesinghe" <shavonne.marietta@studioform.it>
To: "Ivan Sergio Borgonovo" <mail@webthatworks.it>, <pgsql-sql@postgresql.org>
References: 
 <F73B183585950041A3B8A59178A1FEE45D4656@WDF-MX05.de.realTech.net><F73B183585950041A3B8A59178A1FEE47FF68D@WDF-MX05.de.realTech.net><002001c88f37$107363b0$3102a8c0@dream><200803261621.55622.postgres@xmtservices.net><004a01c88fe9$7dc58df0$0602a8c0@DREAM>
	<20080327105436.36e13506@webthatworks.it>
Subject: Re: Export Access 97 to PostgreSQL
Date: Thu, 27 Mar 2008 11:06:39 +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 10:06:38.0142 (UTC)
	FILETIME=[3EF8F5E0:01C88FF2]
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200803/195
X-Sequence-Number: 30523

Strange coz i created the table. Why doesn't it seem to find it??

CREATE TABLE "REGIONI"
(
  "AREA" int4,
  "PERIMETER" int4,
  "REGIONI_" int4,
  "REGIONI_ID" int4,
  "COD_REG" int4,
  "REGIONE" text
) 
WITHOUT OIDS;



From mstepnicki@gmail.com Thu Mar  27 10:14:24 2008
Received: from localhost (unknown [200.46.204.184])
	by postgresql.org (Postfix) with ESMTP id B95862E004D
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Thu, 27 Mar 2008 07:14:24 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024)
	with ESMTP id 66837-06 for <pgsql-sql-postgresql.org@postgresql.org>;
	Thu, 27 Mar 2008 07:14:13 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5
Received: from fg-out-1718.google.com (fg-out-1718.google.com [72.14.220.156])
	by postgresql.org (Postfix) with ESMTP id C83712E0031
	for <pgsql-sql@postgresql.org>; Thu, 27 Mar 2008 07:14:18 -0300 (ADT)
Received: by fg-out-1718.google.com with SMTP id 22so4074311fge.23
	for <pgsql-sql@postgresql.org>; Thu, 27 Mar 2008 03:14:17 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta;
	h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
	bh=AHsKoAhia8qes1aQRsOR1MpHA/UnqhDd8yezX5Pd9iw=;
	b=SrU4WcQANX1+00VfH44bq5AZFM2ieRQBoT1Ft+e65ue5sP4UUDT+ClX0QHO755mGxNmV71FnSxiKSgostl7HjBelRyuRMZVYIXtBUICft9EV0lMWuYoRr4dOVDFX1pxJu3ZXsyFuc0F5uHmLpBnxTtzPGJ7wzek9BeW4YpPcazg=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta;
	h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
	b=tarAyY7f0tcWNIAhr2SNLbkzPWLOJzOybmPH4tRhsAazCKLfu5mNoE0laCo82EyRRMPwWtzck7hJkc8XN8miqxg8u/GMIfIWen/ICf1LZxahoYac1juRt8zuPcd8rilaKlCcsbqYKkQcEyxFTFgc2ti5JtDSoaqhkt5LrS9qiY0=
Received: by 10.86.26.11 with SMTP id 11mr719306fgz.74.1206612857269;
	Thu, 27 Mar 2008 03:14:17 -0700 (PDT)
Received: by 10.86.90.14 with HTTP; Thu, 27 Mar 2008 03:14:17 -0700 (PDT)
Message-ID: <179149fe0803270314u3c25488eu8315be39bfa9a9a3@mail.gmail.com>
Date: Thu, 27 Mar 2008 11:14:17 +0100
From: "=?UTF-8?Q?Marcin_St=C4=99pnicki?=" <mstepnicki@gmail.com>
To: "Shavonne Marietta Wijesinghe" <shavonne.marietta@studioform.it>
Subject: Re: Export Access 97 to PostgreSQL
Cc: "Ivan Sergio Borgonovo" <mail@webthatworks.it>, pgsql-sql@postgresql.org
In-Reply-To: <007201c88ff2$404ffa60$0602a8c0@DREAM>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <F73B183585950041A3B8A59178A1FEE45D4656@WDF-MX05.de.realTech.net>
	<F73B183585950041A3B8A59178A1FEE47FF68D@WDF-MX05.de.realTech.net>
	<002001c88f37$107363b0$3102a8c0@dream>
	<200803261621.55622.postgres@xmtservices.net>
	<004a01c88fe9$7dc58df0$0602a8c0@DREAM>
	<20080327105436.36e13506@webthatworks.it>
	<007201c88ff2$404ffa60$0602a8c0@DREAM>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200803/196
X-Sequence-Number: 30524

On Thu, Mar 27, 2008 at 11:06 AM, Shavonne Marietta Wijesinghe
<shavonne.marietta@studioform.it> wrote:

> COPY REGIONI FROM
(...)
> Strange coz i created the table. Why doesn't it seem to find it??
>
>  CREATE TABLE "REGIONI"

You need to quote the name in your COPY command as well.



From shavonne.marietta@studioform.it Thu Mar  27 10:16:35 2008
Received: from localhost (unknown [200.46.204.184])
	by postgresql.org (Postfix) with ESMTP id D063C2E0031
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Thu, 27 Mar 2008 07:16:35 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024)
	with ESMTP id 75160-01 for <pgsql-sql-postgresql.org@postgresql.org>;
	Thu, 27 Mar 2008 07:16:20 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.5
Received: from smtpout23.attiva.biz (smtpout23.attiva.biz [85.37.16.24])
	by postgresql.org (Postfix) with ESMTP id 5A4562E004D
	for <pgsql-sql@postgresql.org>; Thu, 27 Mar 2008 07:16:23 -0300 (ADT)
Received: from fbcmfe02b04.fbc.local ([192.168.30.33]) by smtpout23.attiva.biz
	with Microsoft SMTPSVC(6.0.3790.1830);
	Thu, 27 Mar 2008 11:16:17 +0100
Received: from DREAM ([88.34.161.130]) by fbcmfe02b04.fbc.local with Microsoft
	SMTPSVC(6.0.3790.1830); Thu, 27 Mar 2008 11:16:15 +0100
Message-ID: <008601c88ff3$988ea810$0602a8c0@DREAM>
Reply-To: "Shavonne Marietta Wijesinghe" <shavonne.marietta@studioform.it>
From: "Shavonne Marietta Wijesinghe" <shavonne.marietta@studioform.it>
To: "Marcin Stepnicki" <mstepnicki@gmail.com>
Cc: <pgsql-sql@postgresql.org>
References: <F73B183585950041A3B8A59178A1FEE45D4656@WDF-MX05.de.realTech.net>
	<F73B183585950041A3B8A59178A1FEE47FF68D@WDF-MX05.de.realTech.net>
	<002001c88f37$107363b0$3102a8c0@dream>
	<200803261621.55622.postgres@xmtservices.net>
	<004a01c88fe9$7dc58df0$0602a8c0@DREAM>
	<20080327105436.36e13506@webthatworks.it>
	<007201c88ff2$404ffa60$0602a8c0@DREAM>
	<179149fe0803270314u3c25488eu8315be39bfa9a9a3@mail.gmail.com>
Subject: Re: Export Access 97 to PostgreSQL
Date: Thu, 27 Mar 2008 11:16:17 +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 10:16:15.0488 (UTC)
	FILETIME=[9718F800:01C88FF3]
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200803/197
X-Sequence-Number: 30525

Thanks.. So it was a uppercase problem ;)

Shavonne.



From roberto.spier@conab.gov.br Thu Mar  27 12:41:56 2008
Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 2F93C2E005F
	for <pgsql-sql-postgresql.org@postgresql.org>;
	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 <pgsql-sql-postgresql.org@postgresql.org>;
	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 <pgsql-sql@postgresql.org>; 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 <roberto.spier@conab.gov.br>
User-Agent: Thunderbird 2.0.0.12 (Windows/20080213)
MIME-Version: 1.0
To: Shavonne Marietta Wijesinghe <shavonne.marietta@studioform.it>
CC: pgsql-sql@postgresql.org
Subject: Re: Export Access 97 to PostgreSQL
References: <F73B183585950041A3B8A59178A1FEE45D4656@WDF-MX05.de.realTech.net>
	<006101c88f2b$6d1cd170$3102a8c0@dream>
	<F73B183585950041A3B8A59178A1FEE45D4657@WDF-MX05.de.realTech.net>
	<007301c88f2d$0e964ad0$3102a8c0@dream>
	<F73B183585950041A3B8A59178A1FEE45D4658@WDF-MX05.de.realTech.net>
	<008e01c88f2f$63766ec0$3102a8c0@dream>
	<F73B183585950041A3B8A59178A1FEE45D465A@WDF-MX05.de.realTech.net>
	<00b501c88f31$99b4edc0$3102a8c0@dream>
	<F73B183585950041A3B8A59178A1FEE47FF68B@WDF-MX05.de.realTech.net>
	<00cf01c88f33$1185e1f0$3102a8c0@dream>
	<F73B183585950041A3B8A59178A1FEE47FF68D@WDF-MX05.de.realTech.net>
	<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