|Pathologically Eclectic Rubbish Lister|
Re: Can I talk to an MS Access DB using Perl?by Asim (Hermit)
|on Feb 02, 2000 at 19:07 UTC||Need Help??|
Here's two snippets of code to get you started, as well. I've been working on this very issue recently! The first connects using DBI::ADO, but works the same for DBI::ODBC with one caveat, as noted below. Also, I'm doing something fairly complex, with making a array of hashs holding the data. The docs for both modules can tell you how to get simpler forms of the data, if you wish:
Now for the Win32::ODBC version -- less commentary, as it's a little less flexible, but more obvious (IMHO):
In general, I'd use DBI unless you have need of Win32::ODBC's features, but please look over both.
Edited by footpad, ~Sun Jan 6 04:48:47 2002 (GMT): Added <CODE> and <P> tags.