If at all possible, use a loader for your database. If not, and you use DBD::CSV, you can simplify your code by using SQL to both access the CSV and load the data. If you want the fastest and most flexible option, use Text::CSV_XS, *not* Text::CSV.