in reply to
Inserting file into a database
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 (?, ?)