open (DATA,") { chomp $line; @array=split(',',$line); my $sth = $dbh->prepare("insert into copy values (?,?,?,?,?,?,?)"); $sth->execute(@array) or die $DBI::errstr; $sth->finish(); }