> I read the CPAN module DBD::CSV and still had some
> questions.
>
> 1)Does this create a "in memory" database with data
> from the spreadsheet for manipulation?
What did reading the source tell you?
>
> 2)This is really cool! Does anyone have a working
> example of inserting, deleting and substituting data
> in cells?
Well, since it is a DBI driver, *any* DBI-aware program could use it,
within the limitations of the subset of SQL that it supports.
>
> In the doc it states:
>
> $dbh->do("UPDATE $table SET id = 3 WHERE id = 1");
>
> and
>
> $dbh->do("DELETE FROM $table WHERE id > 1");
>
> Would $table be the name of the csv file?
>
That is the default behavior, however ...
> > $dbh->{'csv_tables'}->{'SomeName'} = { 'file' => > >
> > 'SomeName20070827.csv'};
> > # tie the table name to the filename
... here you can see they are mapping a table SomeName to the file
"SomeName20070827.csv"
--
Lawrence Statton - [EMAIL PROTECTED] s/aba/c/g
Computer software consists of only two components: ones and
zeros, in roughly equal proportions. All that is required is to
place them into the correct order.
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
http://learn.perl.org/
