Re: Export Access 97 to PostgreSQL

From: Roberto Spier <roberto(dot)spier(at)conab(dot)gov(dot)br>
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-27 12:16:36
Message-ID: 47EB9024.4030305@conab.gov.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Shavonne Marietta Wijesinghe escreveu:
> 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
Export the data, instead! You'd connect (link) to the postgreSQL
database from within access mdb, then run an acc's INSERT INTO query.

hth

--
Spier

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Shavonne Marietta Wijesinghe 2008-03-27 14:47:51 link to Jsp
Previous Message Shavonne Marietta Wijesinghe 2008-03-27 10:16:17 Re: Export Access 97 to PostgreSQL