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