Re: Export Access 97 to PostgreSQL - Mailing list pgsql-sql

From Shane Ambler
Subject Re: Export Access 97 to PostgreSQL
Date
Msg-id 47EA76AB.3010506@Sheeky.Biz
Whole thread Raw
In response to Export Access 97 to PostgreSQL  ("Shavonne Marietta Wijesinghe" <shavonne.marietta@studioform.it>)
List pgsql-sql
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


pgsql-sql by date:

Previous
From: Shawn
Date:
Subject: Question 2 Interval and timestamptz
Next
From: Shawn
Date:
Subject: Re: Export Access 97 to PostgreSQL