my $insert = $db->prepare( 'INSERT INTO articles (title, body) VALUES (?, ?)' ); my @files = glob "$ENV{'DOCUMENT_ROOT'}/data/text/*.txt"; foreach (@files) { open FILE, "$_" or die "error opening $_: $!"; while () { chomp; $insert->execute(split /\t/, $_, 2) or print $db->errstr; } close FILE; }