Perl and Microsoft Access

[powerhouse]

Does anyone know of a way to use Perl to append to an Microsoft Access Database?

I have been searching but cannot find an answer. I would appreciate any advice you may have.

[davidrw]

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);

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?

[sk]

DBI supports ODBC. so you cam use that. Requires DBD::ODBC

Win32::ODBC is also very common.

This link shows how to use Perl to connect to an Access database MS Access Perl

[planetscape]

The following may also be of help:


Before asking a database related question ...
DBI recipes
Perl & Microsoft Access
getting data from a Microsoft Access DB (.mdb file)
Accessing Access DB with DBI
Microsoft Access Database
DBI ODBC!

HTH,

[powerhouse]

Thanks a million!!! I really appreciate the pointers.

Thanks again.