| From: | Shane Ambler <pgsql(at)Sheeky(dot)Biz> |
|---|---|
| To: | Shavonne Marietta Wijesinghe <shavonne(dot)marietta(at)studioform(dot)it> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Export Access 97 to PostgreSQL |
| Date: | 2008-03-26 16:15:39 |
| Message-ID: | 47EA76AB.3010506@Sheeky.Biz |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shawn | 2008-03-26 16:21:55 | Re: Export Access 97 to PostgreSQL |
| Previous Message | Shawn | 2008-03-26 16:05:56 | Question 2 Interval and timestamptz |