Thread: FW: [GENERAL] question on converting M$ Access tables

FW: [GENERAL] question on converting M$ Access tables

From
Michael Davis
Date:
I have an access database that reads an access table structure, creates the
database on Postgres and copies the data from Access into Postgres.  There
are a lot of limitations.  I would like to have a chance to clean it up a
little before releasing it.  I am using it convert my existing Access tables
(approximately 40 of them) to Postgres.

    -----Original Message-----
    From:    William J. Stotts [SMTP:wstotts@sonitrol.net]
<mailto:[SMTP:wstotts@sonitrol.net]>
    Sent:    Wednesday, March 10, 1999 2:21 PM
    To:    pgsql-general@postgreSQL.org
<mailto:pgsql-general@postgreSQL.org>
    Subject:    RE: [GENERAL] question on converting M$ Access
tables


    I have a VB application that uses a M$ Access 97 table to store it's
data
    in. I wish to change to postgres to store the data, and use ODBC to
link
    the postgres tables back to the M$ Access mdb. Are there any
utilities
    that allow me some way of automating the conversion of the mdb table
    structures into postgres short of recreating the tables from scratch
in
    postgres.

    Please email me directly if possible as well as the list.

    Thanks,
    Bill

**************************************************************************
    Bill Stotts                          |  Voice: 860-616-7535
    wstotts@sonitrol.net <mailto:wstotts@sonitrol.net>
|    Fax: 860-616-7589
    Sonitrol Communications Corp.        |
                                         |
    _SONITROL_ Expect the best...        |  Where do you want to GO
tomorrow?

**************************************************************************