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

help / color / mirror / Atom feed
From: Roberto Spier <roberto.spier@conab.gov.br>
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 09:16:36 -0300
Message-ID: <47EB9024.4030305@conab.gov.br> (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 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
  




view thread (9+ messages)

Message-ID: <47EB9024.4030305@conab.gov.br>
Permalink:  ../47EB9024.4030305@conab.gov.br/
Also on:    postgresql.org/message-id/47EB9024.4030305@conab.gov.br

 · 

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: roberto.spier@conab.gov.br, shavonne.marietta@studioform.it
  Subject: Re: Export Access 97 to PostgreSQL
  In-Reply-To: <47EB9024.4030305@conab.gov.br>

* 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