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
Message-ID: <200803261621.55622.postgres@xmtservices.net> (raw)
In-Reply-To: <002001c88f37$107363b0$3102a8c0@dream>
References: <F73B183585950041A3B8A59178A1FEE45D4656@WDF-MX05.de.realTech.net>
<F73B183585950041A3B8A59178A1FEE47FF68D@WDF-MX05.de.realTech.net>
<002001c88f37$107363b0$3102a8c0@dream>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: postgres@xmtservices.net
Subject: Re: Export Access 97 to PostgreSQL
In-Reply-To: <200803261621.55622.postgres@xmtservices.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox