I found these instructions VERY helpful for doing the same thing...
If you have an ODBC link it is super easy to move tables to postgres.
1) In MS Access, right-click on your table and select SAVE AS/EXPORT
2) Select 'ODBC Connection' in the Export Format drop-down list
at the bottom of the SAVE AS screen. ODBC is dead last in the list.
3) You are then prompted to select the ODBC connection you want to save to.
4) Here is the beauty of it-- Your table schema _and_ your data is sent
to your postgres system. No indices are created, but all fields are.
also this link may help - http://sevainc.com/Access/
HTH's,
-jim
-----Original Message-----
From: Horst Herb [mailto:hherb@malleenet.net.au]
Sent: Tuesday, October 02, 2001 11:26 AM
To: Jimmy McDonald
Cc: pgsql-novice@postgresql.org
Subject: Re: [NOVICE] access to postgres?
On Tuesday 02 October 2001 01:44, you wrote:
> ive been trying to convert an access database to a postgres
> database and frankly, i have no idea where to begin.
>
> should i create my postgres db first?
> when im ready to actually import my data, how can i do it?
>
> my access file is on a win2k box and my postgres implementation
> is on a redhat 7.1 box.
>
> a link to a faq that covers this is fine.
> i did some searching around with no luck.
Just download pgadmin, install it, and you can import your Access database
as
easy as clicking your mouse a few times.
Horst
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
