[SLUG] Importing .mdb files to Postgresql

[Mark Gates]

I recall Pete had .mda files not .mdb files. I think he called them
Microsoft Data Access files. So they may be of a different format.

Mark.

-----Original Message-----
From: scarborough-bounces at mailman.lug.org.uk
[mailto:scarborough-bounces at mailman.lug.org.uk] On Behalf Of Chris Sutcliffe
Sent: 17 August 2004 14:20
To: Scarborough Linux Users Group
Subject: [SLUG] Importing .mdb files to Postgresql

At the last meeting somebody, I think it was Pete, asked about using
existing MS Access databases in Linux.

Firstly, I must warn you that I have not done this myself but through
advice on the Open University newsgroups that I frequent, I found out
the following:

PGadmin2 is a database design and admin tool for PostgreSQL on windows,
see: 
<http://gborg.postgresql.org/project/pgadmin2/projdisplay.php>. 

It also has a database migration tool for exporting tables and data to a
PostgreSQL database (in this case your Access .mdb files) via ODBC
(drivers are included). When you download the PGadmin2 tool, you also
need the pgMigration (version 1.6) plugin as well, both can be
downloaded from: <http://pgadmin.postgresql.org/pgadmin2/downloads/>

hope this helps


Chris
-- 
Chris Sutcliffe
Linux User #160319
<chris at snbcomputers.com>
Scarborough LUG <http://www.scarborough.lug.org.uk/>