From: Allan Huffman <huffmana@ppc.pims.org>
To: Nicolas Huillard <nhuillard@ghs.fr>
To: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] Replication between MS Access and PostgreSQL
Date: Wed, 27 Oct 1999 15:25:06 +0200
Message-ID: <3816FD32.2F30921C@ppc.pims.org> (raw)
References: <01BF206F.D833DF00@agen.int.ghs>
You can export the MS Access tables to Postgres as long as the ODBS.exe has been run and set up from the
control panel "32 ODBC" configuration panels that are loaded from the .exe. You will need the Host name,
database name, User and Password, and use the default PostgreSQL Postmaster port number. The Postmaster
has to be running with the database allocated but the table must not already exit. Then do the following:
1) File select "Export as"
2) To an External File or Database
3) Change the "Save as type" to ODBC Databases()
4) Verify the name (all lower case) and click OK
5) Select "DSN Name" to be "MS Access 97 Databases (not sharable).dsn"
6) Click OK
All table names and column names must be lower case (at least for PostgreSQL 6.5.2 running on Solaris).
Cheers,
Allan
Nicolas Huillard wrote:
> Hello,
>
> Are there any tools on earth that allow replication between an Access database and a PostgreSQL server ?
> I think about things like :
> * standalone Windows app that have two ODBC connections and replicate data between the two,
> * VBA modules to insert in the Access database,
> * other stuff,
> I don't necessarily need a true replication. If there are a few impossible things, I could still be OK.
>
> TIA,
>
> Nicolas Huillard
> G.H.S
> Directeur Technique
> Tél : +33 1 43 21 16 66
> Fax : +33 1 56 54 02 18
> mailto:nhuillard@ghs.fr
> http://www.ghs.fr
>
> ************
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-interfaces@postgresql.org
Cc: huffmana@ppc.pims.org, nhuillard@ghs.fr
Subject: Re: [INTERFACES] Replication between MS Access and PostgreSQL
In-Reply-To: <3816FD32.2F30921C@ppc.pims.org>
* 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