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:
FAQ available at http://www.roth.net/odbc/odbcfaw.htm. Luck.$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();
|
---|
In Section
Seekers of Perl Wisdom