my $sql = <prepare($sql); while (){ chomp; my @values = split(',',$_); # what do you do if one value contains a comma? # remove quotes here $sth->execute(@values); };