You can use DBI, and use DBD::ODBC ... There is also Win32::ODBC, but i recommend DBI over it for placeholders and much wider user/support base. Search here on perl monks for "access" and those modules for examples/related nodes. Also be sure to check out the "databases" section in the Tutorials.

Once you have a database handle using DBI/DBD, the code could be as simple as:

my $sql = "INSERT INTO foo (bar, stuff) VALUES (?,?)";
my @bind = ( 3, 42 );
$dbh->do($sql, {}, @bind);
[download]

Update: Searching for "access" here on PM immediately found these:

• Can I talk to an MS Access DB using Perl?
• DBD driver for MS Access
• Can I interface MS Access on Unix?
• Re: How can I talk to an Access database using perl?
• Re: How can I talk to an Access database using perl?