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

	MAIN INDEX	SEARCH POSTS	WHO'S ONLINE	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 (4740 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 (4740 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 (4740 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 (4740 views) Re: Using perl to get info from Access 2000 [In reply to] Can't Post Hey, I just got here myself

Announcements     PerlGuru Announcements Perl Programming Help     Frequently Asked Questions     Beginner     Intermediate     Advanced     Regular Expressions     mod_perl     DBI     Win32 Programming Help Fun With Perl     Perl Quizzes - Learn Perl the Fun Way     Perl Golf     Perl Poetry Need a Custom or Prewritten Perl Program?     I need a program that...     I Need a Programmer for Freelance Work     Throw Down The Gauntlet General Discussions     General Questions     Feedback     Tutorial/Article Suggestions for The Learning Cent     Internet Security Other Programming Languages     Javascript     PHP

Search this forum this category all forums for All words Any words Whole Phrase (options)

Powered by Gossamer Forum v.1.2.0

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