my @question_marks = ('?') x @columns; #### else { local $" = ', '; $sth = $dbh->prepare( "INSERT INTO $table (@columns) VALUES (@question_marks)" ); $sth->execute(@csv_values); }