Skip site navigation (1) Skip section navigation (2)

Re: plugin to convert ms access tables

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 (view raw or flat)
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-----


In response to

pgadmin-support by date

Next:From: Donald FraserDate: 2004-08-16 21:57:53
Subject: load project problems with pgAdmin II
Previous:From: Dave PageDate: 2004-08-16 20:48:33
Subject: Re: plugin to convert ms access tables

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group