open(FILE,"logfile.txt")||die;
while($line=<FILE>){
($field1,$field2,$field3)=split(/:/,$line);
$sth = $dbh->prepare ('INSERT INTO tablename (fieldname1,fieldname2,fieldname3) VALUES(?,?,?)');
$sth->execute ($field1,$field2,$field3);
}
$sth->finish ();