http://www.perlmonks.org?node_id=225596


in reply to Inserting file into a database

Hi Anony,

I don't use Access very much. I usually use Oracle and
Oracle comes with a utility called sqlldr which is
used to load files into database tables. I bet Access
has similar functionality.

If not or if you just feel like it you can go with
the roll-your-own approach. But I would suggest using
"place holders" in your SQL ...
my $statement = "Insert into tableOne (filename, letter) values (?, ?) +"; ... $sth->execute($filename, $letter);