Re: Re: MS Access data to PostgrSQL data

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.
>