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@postgresql.org
[mailto:pgsql-general-owner@postgresql.org]On Behalf Of suresh s
Sent: Thursday, December 12, 2002 4:00 AM
To: pgsql-general@postgresql.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