Re: Is it possible to Import tables and its data from Ms Access

Suresh,
It's possible to dump entire tables from Access to Postgres via ODBC.
Select your table in the tables tab, go to the File menu and choose Export,
select ODBC in Save as type, indicate your ODBC data source, specify a table
name and that should do it.
I'd strongly advise against it however, as the tables you get don't tend to
make a lot of sense design wise in Postgres. It does weird things with
autonumber fields, etc. You'd probably be better off creating the tables in
Postgres and just appending the data to them.
Thanks,
Peter Darley

-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org]On Behalf Of suresh s
Sent: Thursday, December 12, 2002 4:00 AM
To: pgsql-general(at)postgresql(dot)org
Subject: [GENERAL] Is it possible to Import tables and its data from Ms
Access

Hi ,

I have about 40 tables designed in access and their
data in windows PC,

can i import those tables and data into postgres in
linux PC

Ma Access got an option to export data into postgres,
do i have to create tables in postgres or tables can
also be imported,

please let me know , How it can be done

thank u

suresh

__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org