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
>
There is also a CPAN module to parse out comma-delimited data:

Text::CSV_XS

and a DBD module that builds on that:

DBD::CSV

I think the perldoc for that module even uses Excel data as an example.