Convert Microsoft Access Database to PostgreSQL Dump Files (VBA recipe)

Convert Microsoft Access database into Postgresql DDL statements using DAOs (Database Access Objects).

by Daniel Clark daniel@qcode.co.uk [28/01/2015].

MSAccessTables2PGDump

Creates PostgreSQL dump file to recreate basic table datamodel. Handles:

• Conversion of MS Access data types to PostgreSQL data types.
• Conversion of MS Access default values to PostgreSQL default values.
• Not null constraints.
• Column validation Rules (column check constraints).
• Table validation Rules (table check constraints).
• Primary key contraints.

note: check constraints may contain MS Acess specific functions and syntax which must be manually converted to PostgreSQL equivalents.

note: Boolean fields will default to false (if a default value is not specfied) and will enforce not null constraints.

note: Autonumber fields will enforce a not null constraint and will adopted the integer PostgreSQL data type.

MSAccessIndexes2PGDump

Creates PostgreSQL dump file to recreate indexes.

MSAccessForeignKeys2PGDump

Creates PostgreSQL dump file to recreate foreign key constraints.

note: If you MS Access Database performs case insenstive string matching you may have to sanitise your data before you are able to recreate foreign keys in PostgreSQL.

MSAccessAutoNumbers2PGDump

Creates PostgreSQL dump file to create sequences for MS Access autonumber fields and set default values.

note: Sequences will be initialised to the max value of the autonumber field + 1.

MSAccessRecords2PGDump

Creates PostgreSQL dump file to load record data

---

Based on Reverse engineer MS Access/Jet databases (Python recipe) by M.Keranen mksql@yahoo.com [07/12/2000].

---

[Qcode Software Limited] qcode