Thread: 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

I use PGAdmin II and its database migration plugin to import tables from
Access or other ODBC source. You can find a link in the users lounge of the
Postgres site.
On Thursday 12 December 2002 03:59 am, suresh s wrote:
> 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

--- Adrian Klaver <aklaver@attbi.com> wrote:
> I use PGAdmin II and its database migration plugin
> to import tables from
> Access or other ODBC source.

I second this recommendation.  PGAdminII worked very
well for me recently in a similar exercise.  You just
tell the migration utility which PostgreSQL database
you are exporting to, then tell it which tables you
are exporting, and the rest is done: tables, indexes,
primary keys, foreign keys are all created for you.

http://pgadmin.postgresql.org

Suggestions, based on my recent experience:
PostgreSQL is much more strict about identifiers (i.e.
names of tables and other database objects) than
Access is.  Here is a link that tells you more:

http://www.postgresql.org/idocs/index.php?sql-syntax.html#SQL-SYNTAX-IDENTIFIERS

I suggest that you consider changing the names of any
tables and columns that:
* Are mixed case
* Contain characters not allowed in PostgreSQL
identifiers
* Are PostgreSQL key words.

Any of those will _always_ need to be quoted wherever
used, which is a pain to keep track of, and a trap
just waiting to happen.  PGAdminII migration utility
has an option that will change all names to lower
case.  Access won't care about that change.  Other
changes may be more difficult, because you will then
need to change them wherever they appear in your
application, but this may turn out to be less trouble
for you.

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

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