Beefy Boxes and Bandwidth Generously Provided by pair Networks
There's more than one way to do things
 
PerlMonks  

Answer: How can I talk to an Access database using perl?

by Anonymous Monk
on May 03, 2000 at 22:40 UTC ( #10143=categorized answer: print w/replies, xml ) Need Help??

Q&A > database programming > How can I talk to an Access database using perl? - Answer contributed by Anonymous Monk

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.

Log In?
Username:
Password:

What's my password?
Create A New User
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others making s'mores by the fire in the courtyard of the Monastery: (7)
As of 2019-12-06 13:37 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Strict and warnings: which comes first?



    Results (155 votes). Check out past polls.

    Notices?