Thread: plugin to convert ms access tables

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?


-- 
Roger Durañona Vargas
Linux user #180787
A cada momento nos rodea lo desconocido. Es alli
donde uno tiene que buscar el conocimiento.
Paul Muad'Dib Atreides. Children of Dune

> -----Original Message-----
> From: pgadmin-support-owner@postgresql.org
> [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of
> Roger D. Vargas
> Sent: 16 August 2004 21:40
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] plugin to convert ms access tables
>
> 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?

No, unfortunately that plugin died with pgAdmin II.

Getting php to connect to ms sql isn't too hard though (I have informix,
SQL Server and PostgreSQL support in one of my PHP's). You just need to
download and install FreeTDS.

Regards, Dave

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