CGI/Perl Guide | Learning Center | Forums | Advertise | Login
Site Search: in

  Main Index MAIN
INDEX
Search Posts SEARCH
POSTS
Who's Online WHO'S
ONLINE
Log in LOG
IN

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

 



Michael
Deleted

May 21, 2000, 11:42 AM

Post #1 of 4 (2557 views)
Using perl to get info from Access 2000 Can't Post

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

Post #2 of 4 (2557 views)
Re: Using perl to get info from Access 2000 [In reply to] Can't Post

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

Post #3 of 4 (2557 views)
Re: Using perl to get info from Access 2000 [In reply to] Can't Post

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

Post #4 of 4 (2557 views)
Re: Using perl to get info from Access 2000 [In reply to] Can't Post

Hey, I just got here myself Smile

 
 


Search for (options) Powered by Gossamer Forum v.1.2.0

Web Applications & Managed Hosting Powered by Gossamer Threads
Visit our Mailing List Archives