Re: Re: MS Access data to PostgrSQL data

That's sort of the problem though... the person never quite mentioned where
PHP was located.

I agree with you though, If you have Access and postgreql, why write a whole
new program in a third language to get the data over?

There has to be other reasons if the person wants to make it that difficult.
;)

Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
http://www.rutgersinsurance.com
----- Original Message -----
From: "Lamar Owen" <lamar.owen@wgcr.org>
To: "Tim Uckun" <tim@diligence.com>
Cc: <pgsql-general@postgresql.org>
Sent: Thursday, January 18, 2001 3:25 PM
Subject: Re: [GENERAL] Re: MS Access data to PostgrSQL data


> Tim Uckun wrote:
> >
> > >>hi,
> > >>can anyone help me ? i need to convert a ms access .mdb file into
> > >>somthing readable so i can insert it into my postgreSQL db...
> > >>does anyone have any experiance? (preferably using PHP)
> > >>Robert Korteweg
> > >>The Netherlands
> >
> > Here is your steps.
> >   1) Create your destination table in postgres
> > 2)  Export your data to a comma delimeted format
> > 3)  save this perl script to a file
>
> Good script.
>
> But, if you have the PostgreSQL ODBC driver installed on the windows
> machine, you can use Access's SaveAs/Export function to save it directly
> into a PostgreSQL table.  Although, that might be overkill for this, I
> do this quite alot (did it five times today to get some data over to the
> real RDBMS.....).
> --
> Lamar Owen
> WGCR Internet Radio
> 1 Peter 4:11