[Nottingham] Nottingham Perl Mongers (good/bad idea?)
Matthew Sackman
matthew at sackman.co.uk
Mon Feb 16 21:21:46 GMT 2004
On Mon, Feb 16, 2004 at 07:58:42PM +0000, Duncan John Fyfe wrote:
> On Mon, 16 Feb 2004, Andy Brown wrote:
> > Lesson 7
> > Total insanity, such as using perl to read CSV files and stuff data
> > into a Microsoft SQL Server (well, MSDE) database.
> >
> > (and yes, this probably *is* the best way of doing the data transfer)
>
> Why is this insane ?
> DBD::CSV -> DBD::*
> Is a great way of loading data into a database while leaving the data
> humanly mongable and in a database neutral format.
The insane bit is not realising DBD::CSV exists and trying to write a
csv parser in a one liner.
Matthew
--
Matthew Sackman
BOFH excuse #48:
bad ether in the cables
More information about the Nottingham
mailing list