Thread

Fw: [GENERAL] Import table from MS Access?

davidb@vectormath.com — 2000-01-04T18:24:48Z

When I sent this I overlooked the fact that you specified Access 2000.  We
use Access 97.
Sorry,
David Boerwinkle
-----Original Message-----
From: davidb@vectormath.com <davidb@vectormath.com>
To: Mike Mascari <mascarm@mascari.com>; Chris Carbaugh
<cjdesigns@sprintmail.com>
Cc: pgsql-general@postgreSQL.org <pgsql-general@postgreSQL.org>
Date: Tuesday, January 04, 2000 12:22 PM
Subject: Re: [GENERAL] Import table from MS Access?


>We've had good luck with something we found at:
>
>http://www.sevainc.com/
>
>David Boerwinkle
>
>-----Original Message-----
>From: Mike Mascari <mascarm@mascari.com>
>To: Chris Carbaugh <cjdesigns@sprintmail.com>
>Cc: pgsql-general@postgreSQL.org <pgsql-general@postgreSQL.org>
>Date: Sunday, December 26, 1999 6:08 PM
>Subject: Re: [GENERAL] Import table from MS Access?
>
>
>>Chris Carbaugh wrote:
>>
>>> What is the best way to import a table from Microsoft Access 2000?
>>>
>>> I was able to export to a text file from access, but this was only the
>>> data.  Can I export/import the table definition as well?
>>>
>>> I have been using pgaccess to administer my DB.  It seems I can't tell
>>> it to import a comma delimited file?  Is there any way around this?
>>>
>>> Any help is greatly appreciated.
>>>
>>> Chris
>>>
>>
>>One way is to use the PostgreSQL ODBC driver from Insight (search
>>yahoo.com for: postgres Insight ODBC), and use the File->Export function
>>in Access to export the tables to PostgreSQL. There are a few problems
>>with this method, though, if I recall correctly:
>>
>>1. Table and field names will be case-sensitive, so if you have a table
>>in Access called Employees with a field HireDate,  then in PostgreSQL,
>>you must refer to this as "Employees"."HireDate", not employees.hiredate,
>>although you could programmatically rename the tables by performing an
>>update on pg_class and pg_attribute.
>>
>>2. Column constraints are not exported. If I recall (its been some time),
>>column constraints are not exported from Access when the tables are
>>created. And, unfortunately, there's no easy way to add them in
>>PostgreSQL using an ALTER TABLE statement.
>>
>>Nevertheless, it might be easier to perform the export in Access using
>>ODBC, pg_dump the database to a text file, perform whatever cleanup is
>>necessary, and then reimport.
>>
>>Also, I rember that there's a PostgreSQL upsizing tool somewhere that
>>does all this stuff for you. But for the life of me I can't remember
>>where...
>>
>>Hope that helps,
>>
>>Mike Mascari
>>
>>
>>
>>************
>>
>