> Something like
> #!/usr/bin/perl
> use strict;
> use DBI;
>
> my $dbh =
> DBI->connect("DBI:CSV:f_dir=/dir/with/the/csvs")
> or die "Cannot connect: " . $DBI::errstr;
>
> $dbh->{'csv_tables'}->{'SomeName'} = { 'file' =>
> 'SomeName20070827.csv'};
> # tie the table name to the filename
>
> my $sth = $dbh->prepare('UPDATE SomeName SET Foo =
> Foo * Bar');
> $sth->execute();
> # specify an execute the action
>
> __END__
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?
2)This is really cool! Does anyone have a working
example of inserting, deleting and substituting data
in cells?
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?
thank you
:)
____________________________________________________________________________________
Fussy? Opinionated? Impossible to please? Perfect. Join Yahoo!'s user panel
and lay it on us. http://surveylink.yahoo.com/gmrs/yahoo_panel_invite.asp?a=7
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
http://learn.perl.org/
