From: | <davidb(at)vectormath(dot)com> |
---|---|
To: | <bmccoy(at)chapelperilous(dot)net>, "Kevin Leclaire" <kevin(at)virtualnav(dot)com> |
Cc: | <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Importing Data into Postgresql from MS Access |
Date: | 2000-10-12 21:32:16 |
Message-ID: | 002601c03493$e82e28f0$0602010a@bullwinkle.VECTORMATH |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
For Access97 we used something we found at:
http://www.sevainc.com/Access/index.html
and it worked well.
David Boerwinkle
-----Original Message-----
From: bmccoy(at)chapelperilous(dot)net <bmccoy(at)chapelperilous(dot)net>
To: Kevin Leclaire <kevin(at)virtualnav(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org <pgsql-novice(at)postgresql(dot)org>
Date: Thursday, October 12, 2000 4:13 PM
Subject: Re: [NOVICE] Importing Data into Postgresql from MS Access
>On Thu, 12 Oct 2000, Kevin Leclaire wrote:
>
>> Does anyone know of a utility which can easily convert MS Access tables
into
>> Postgres?
>
>pgAdmin has an Access migration utility. It works through the Pg ODBC
>driver. See http://www.pgadmin.freeserve.co.uk/
>
>> Alternatively, I can export to any format that MSAccess supports (e.g.
>> comma-delimited text), but would like to know if there are any import
>> utilities which will simplify the import process into postgres so I don't
>> have to write a script for 100 fields X thousands of records.
>
>If you export into some kind of delimited format, you can easily use the
>COPY or /copy commands with psql.
>
>Brett W. McCoy
> http://www.chapelperilous.net
>---------------------------------------------------------------------------
>The full potentialities of human fury cannot be reached until a friend
>of both parties tactfully interferes.
> -- G.K. Chesterton
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | David Huttleston Jr | 2000-10-12 21:53:39 | Re: Importing Data into Postgresql from MS Access |
Previous Message | Jean-Christophe Boggio | 2000-10-12 21:13:20 | Re: Importing Data into Postgresql from MS Access |