Search this (and the novice) list for importing from Excel. I recently
posted some tips there on using tab delimited text files and the copy
command. DBD has a file size limit.
--rob
----- Original Message -----
From: "Keith G. Murphy" <keithmur@mindspring.com>
To: <pgsql-general@postgresql.org>
Sent: Friday, January 19, 2001 11:13 AM
Subject: 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.
>