From: Paul Smith <paul@...>
Date: 2009-10-29T00:08:31+09:00
Subject: Re: SQL Shell for MS Access

On Wed, Oct 28, 2009 at 2:26 PM, Max Williams
<toastkid.williams@gmail.com> wrote:
> I connected to an mdb (access db) in windows with the 'win32ole' gem.  I
> also got this class from a blog post by David Mullet:
> http://rubyonwindows.blogspot.com/2007/06/using-ruby-ado-to-work-with-ms-access.html
>
> which also has a guide on how to connect.
>
> I modified the class on this page to return results as an array of
> hashes, like ActiveRecord's find_rows method, and added a "find" method
> which just takes an sql string.  So, it's pretty like mysql (my desire
> as well, i was amazed to discover that access has no sql command line).
>
> If this has problems then blame me and not David :)  Here's my complete
> class, see the blog post by David above on how to use it.
>
> class AccessDb
>

Thanks Max!  Making a painful job easier, one step at a time.

-- 
Paul Smith
http://www.nomadicfun.co.uk

paul@pollyandpaul.co.uk