×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

PERL and Access

PERL and Access

PERL and Access

(OP)
I have a question.  I need to do a script that checks a website and compairs the information on that site against the information in MS Access.

Is this possible through PERL?

RE: PERL and Access

Yes it is possible.

Have a look at: : http://www.symbolstone.org/technology/perl/DBI/

Briefly, DBI is a Perl module that connects you to a database. Through DBI you can use quite a few databases including Access. One of its advantages is that you can write your perl application using the Perl::DBI and Acess and then, when you need to upgrade move to a bigger database like Oracle without changes.

I use DBI at work and have found it to be very reliable.

Another option is the ODBC Perl module which is also quite widely used. I have no experience with Perl::ODBC but have heard that it's OK.

Mike
michael.j.lacey@ntlworld.com
Cargill's Corporate Web Site

RE: PERL and Access

(OP)
I'll look into these, thanks!

RE: PERL and Access

Can an MS Access file be read under Perl on a Linux server and if so, how?

Don

RE: PERL and Access

You *can* read/write an access file on a Win machine from a linux (or any) box using DBI and its proxy server. This isn't quite what you asked for but may serve your purposes.

The proxy server is run on the Win box, Perl (using DBI) runs on the Linux box.

This is quite well documented in the Perl DBI book (The Cheetah Book) and in the online DBI documentation.

On the other (and simpler) hand. If you only need to have the data from the Access db available to the linux box (as oppsed to being able to read and write it at the same time as other processes) you could just export the data from Access as a .csv file, transfer the file and process the data using Perl without any clever modules..

Mike
michael.j.lacey@ntlworld.com
Cargill's Corporate Web Site

RE: PERL and Access

Thanks Mike!  I was trying to avoid the import/export stuff but I thought it might be the only way. Since that's the case, I'll come up with another way to maintain the data in flat text format rather than import/export - upload/download all the time. I found a prewritten script that will do it easily, but it would need a separate copy for each table, not really a big deal excpept that it is a large script.  Maybe I can come up with a subroutine to load the setup part needed for each one into the same script.

Now if I can find a Perl application that can tie the two tables together in a presentable form to match the current HTML version that I am using . . .

Don

RE: PERL and Access

Mike, I have heard of DBI but don't know much about it. Maybe you could tell me, either directly or via this forum?

My Linux server is through a service provider so, unfortunately, I cannot install anything that would have to go on their end of things.  I have access to my own account and Perl, but that's about it.  If there were some kind of Perl library that I could load on my account that would read Access files, then I could do it, or if DBI had its own format and could act as a replacement I could do it.  

The site I would need it on is an informational site run for free out of my pocket so obviously I couldn't buy something that may or may not work to do what I need!  I may have to get a programmer to do it for me (if I can find one) since my skills in Perl are very limited to the point of not being there.

Don

RE: PERL and Access

Hi Don,

The link to find out all about DBI is:

http://www.symbolstone.org/technology/perl/DBI/

and I'm happy to help with what I know about it either here on via email (probably better here in a new thread so that others can contribute to - as long as it's not confidential of course)

If you're running Perl on your ISP's box then DBI would need to be installed there - which it may or may not be.

If it is - there's a DBI module that can work with .csv files as if they were an SQL database so it might be worth a look if your ISP does support DBI. If they don't they might be persuaded to install DBI and DBD::CSV which is all it would take I think.

Mike
michael.j.lacey@ntlworld.com
Cargill's Corporate Web Site

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close