RE: [GENERAL] Import table from MS Access?

Download and install the latest Microsoft Data Access Componants from
Microsoft. That mostly fixed me when I was having problems.

But, I should also add that when reformated my entire hard drive and
reinstalled Windows, Office 2000, and MDAC, things got a lot better. I hate
to think what that means.

David Barnes

-----Original Message-----
From: owner-pgsql-general(at)postgreSQL(dot)org
[mailto:owner-pgsql-general(at)postgreSQL(dot)org]On Behalf Of Jose Soares
Sent: Wednesday, January 05, 2000 11:45 AM
To: davidb(at)vectormath(dot)com
Cc: Mike Mascari; Chris Carbaugh; pgsql-general(at)postgreSQL(dot)org
Subject: Re: [GENERAL] Import table from MS Access?

I have some troubles to access PostgreSQL tables linked to M$-Access2000.
Does anyone have any ideas, how to do that?
Thanks.

davidb(at)vectormath(dot)com wrote:

> We've had good luck with something we found at:
>
> http://www.sevainc.com/
>
> David Boerwinkle
>
> -----Original Message-----
> From: Mike Mascari <mascarm(at)mascari(dot)com>
> To: Chris Carbaugh <cjdesigns(at)sprintmail(dot)com>
> Cc: pgsql-general(at)postgreSQL(dot)org <pgsql-general(at)postgreSQL(dot)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
> >
> >
> >
> >************
> >
>
> ************

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