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.
