Perl and Microsoft Access

powerhouse has asked for the wisdom of the Perl Monks concerning the following question:

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.

thx,
Richard

Comment on Perl and Microsoft Access

Replies are listed 'Best First'.
Re: Perl and Microsoft Access by davidrw (Prior) on Sep 03, 2005 at 02:13 UTC
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?	[reply] [d/l]
Re: Perl and Microsoft Access by sk (Curate) on Sep 03, 2005 at 02:15 UTC
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	[reply]
Re: Perl and Microsoft Access by planetscape (Chancellor) on Sep 03, 2005 at 04:43 UTC
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, planetscape	[reply]
Re: Perl and Microsoft Access by powerhouse (Friar) on Sep 03, 2005 at 03:47 UTC
Thanks a million!!! I really appreciate the pointers. Thanks again. thx, Richard	[reply]

Back to Seekers of Perl Wisdom