Home: Perl Programming Help: Advanced:
Using perl to get info from Access 2000



Michael
Deleted

May 21, 2000, 11:42 AM


Views: 5950
Using perl to get info from Access 2000

I am looking for some guide to show me how to get specific information out of an Access 2000 database. The script would run on the same machine, and have all the right permissions. I've checked several Access for Dummy's ect. books, but they just aren't that helpful.
Any help?


TheGame+
Deleted

May 21, 2000, 1:31 PM


Views: 5950
Re: Using perl to get info from Access 2000

If you set up an ODBC DSN to your Access database, you could use either the standard DBI database interface module with the DBD::ODBC driver, or use the Win32::ODBC module.
There is an example of using DBI/DBD with the Northwinds Access database here : http://tlowery.hypermart.net/perl_dbi_dbd_faq.html#DBDODBCAccess
And the Win32::ODBC FAQ is available here : http://www.roth.net/perl/odbc/faq/

In general, I'd recommend using the DBI/DBD method.

Another way would be to use the WIN32::OLE module and call the Access engine itself - but that's mostly of interest if you want to e.g. access macros that are defined within your Access database application.


Michael
Deleted

May 21, 2000, 3:03 PM


Views: 5950
Re: Using perl to get info from Access 2000

Thanks, I have about a week to get this working!
Love this site, you guys are the greatest!
I've tracked half a dozen perl archives that just curled up and died! Keep up the good work!


TheGame+
Deleted

May 21, 2000, 3:39 PM


Views: 5950
Re: Using perl to get info from Access 2000

Hey, I just got here myself Smile