From: | Devrim GUNDUZ <devrim(at)gunduz(dot)org> |
---|---|
To: | "Roger D(dot) Vargas" <roger(at)ehtsc(dot)co(dot)cu> |
Cc: | pgadmin-support(at)postgresql(dot)org |
Subject: | Re: plugin to convert ms access tables |
Date: | 2004-08-16 20:58:23 |
Message-ID: | Pine.LNX.4.44.0408162349580.23696-100000@emo.org.tr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hi,
On Mon, 16 Aug 2004, Roger D. Vargas wrote:
> I remember in old pgadmin 2 there was a plugin to convert access tables
> to postgres. I urgently need to convert periodically an access table to
> postgres (or find a way to make php connect ms sql), so, does that
> plugin still exists or there is some solution for this?
A few months ago I converted an M$ Access db to PostgreSQL for testing
purposes.
First, I've installed PostgreSQL ODBC driver and made the
settings so that I could connect to my linux server via that. After,
opened M$ Access and right clicked each database so that I could export
them using ODBC driver of PostgreSQL. I don't remember how I
exactly did it. I don't have a windows near here, so I can't verify these
steps but I'm sure that you'll be able to succeed in converting them. ODBC
driver directly passed the schema and data to PostgreSQL.
Also, http://techdocs.postgresql.org/#convertfrom has some articles for
conversion but i did not test them.
- -HTH
Regards,
- --
Devrim GUNDUZ
devrim~gunduz.org devrim.gunduz~linux.org.tr
http://www.tdmsoft.com
http://www.gunduz.org
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)
iD8DBQFBIR/xtl86P3SPfQ4RAvrVAJ4+RccNw2Lx8MCf6DUm8JrTZ5/HUgCffHhJ
gY4/9Zp3Ymf8qBCAohNCsBY=
=Xsl7
-----END PGP SIGNATURE-----
From | Date | Subject | |
---|---|---|---|
Next Message | Donald Fraser | 2004-08-16 21:57:53 | load project problems with pgAdmin II |
Previous Message | Dave Page | 2004-08-16 20:48:33 | Re: plugin to convert ms access tables |