Projects / exportSQL

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

RSS Recent releases

  •  20 Mar 2002 09: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 11: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.

  •  30 Jan 2001 06:12

    Release Notes: A patch has been applied for PostgreSQL support.

    RSS Recent comments

    12 Apr 2001 08:56 dpavlin

    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.

    Screenshot

    Project Spotlight

    Bitcoin

    A peer-to-peer network-based digital currency.

    Screenshot

    Project Spotlight

    MySQL

    A fast SQL database server.