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>

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