exportSQL
exportSQL is a script to export all tables in a MS-Access database file to several text files containing SQL instructions: one to delete tables which are about to be created, another to create tables, and one to insert data into the new tables. The resulting table structure and data will resemble the current Access database as much as possible.
| Tags | Database Database Engines/Servers |
|---|
Recent releases
- 20 Mar 2002 14:47
Release Notes: This release adds fixes for non-valid characters in field names, boolean values in insert statements, output of created table in a separate file, cr/lf in output files, and invalid index creation with PostgreSQL.
- 04 Jun 2001 15:30
Release Notes: Indexes were added to the PostgreSQL dump file format. Comments were improved. Limited support was added for constrains from Access. These constraints are not conveted, but they are dumped to file as comments.
- 27 Jul 2000 08:50
Release Notes: A patch has been applied for PostgreSQL support.
Recent comments
support for Microsoft Access 2000
Lates changes to this project include additional
note about modules which are
required to be checked in Tools/References for
this module to work.
If you had problems with this module, add
Microsoft DAO Object Library and uncheck
Microsoft ActiveX Data Objects Library.
dpavlin
28 Jun 1998 11:51
