pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Shane Ambler <pgsql@Sheeky.Biz>
To: Shavonne Marietta Wijesinghe <shavonne.marietta@studioform.it>
Cc: pgsql-sql@postgresql.org
Subject: Re: Export Access 97 to PostgreSQL
Date: Thu, 27 Mar 2008 02:45:39 +1030
Message-ID: <47EA76AB.3010506@Sheeky.Biz> (raw)
In-Reply-To: <002001c88f37$107363b0$3102a8c0@dream>
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>

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



view thread (9+ messages)  latest in thread

Message-ID: <47EA76AB.3010506@Sheeky.Biz>
Permalink:  ../47EA76AB.3010506@Sheeky.Biz/
Also on:    postgresql.org/message-id/47EA76AB.3010506@Sheeky.Biz

 · 

reply
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: pgsql@Sheeky.Biz, shavonne.marietta@studioform.it
  Subject: Re: Export Access 97 to PostgreSQL
  In-Reply-To: <47EA76AB.3010506@Sheeky.Biz>

* 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