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


in reply to How can I talk to an Access database using perl?

Win32::ODBC comes bundled w/ the newer builds of ActiveState Perl (http://www.activestate.com). Define your Access DB as an ODBC source in the control panel, then call it as such. Example:
$SQLcall = "SELECT * FROM main WHERE main.whatever = '$whatever'"; use Win32::ODBC; $DB = new Win32::ODBC("TheNameYouGaveYourODBCSource"); $DB->Sql("$SQLcall"); $DB->FetchRow(); $check = $DB->Data(); $getwhatever = $DB->Data("whateverfieldnameyouwant +"); $DB->Close();
FAQ available at http://www.roth.net/odbc/odbcfaw.htm. Luck.