From: arobbo <arobbo61@...>
Date: 2007-06-05T02:50:17+09:00
Subject: Using ADO to connect to an Access database in Ruby

Hi guys

I'm trying to get Alexa web stats on 1,000 firms websites.  I have the
website addresses etc in an MS Access database.

I've used the example Ruby code from Alexa Web Information Service to
get web stats manually using Ruby but am a little bit stuck as to the
next two steps to achieve my goal.

Step 2.  How do I connect to an Access Database to gather my URLs ?
In the past i've used ADO to connect to an MS Access database

and

Step 3. How would I insert the results back into the database ?

Any ideas on how i'd go about steps 2 and 3 would be greatly
appreciated

Cheers

Andy