Re: plugin to convert ms access tables

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