[SLUG] Importing .mdb files to Postgresql

[Chris Sutcliffe]

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/>