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 09:47
Changes: 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 11:30
Changes: 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.
- 30 Jan 2001 06:12
Changes: A patch has been applied for PostgreSQL support.
- All comments
Recent commentssupport 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.