From: William James <w_a_x_man@...>
Date: 2006-02-20T20:53:30+09:00
Subject: Re: Microsoft Access Automation


Leslie Viljoen wrote:
> Hey everyone
>
> I struggled a bit on trying to get data out of an Access database using
> Ruby, so I thought I'd share the
> results here in case someone else needs this. I found OLEDB automation
> to be the easiest method.
>
> Excel Automation is also extremely easy and you can use the macro writer
> to create much of the
> VBA code that you can then adapt directly to Ruby.
>
> One more thing - getrows returns an array that's "rotated" - I added a
> "rotate" routine to my Array
> class to sort that out - see the end. If anyone can improve on the
> routine, please post! It looks
> very much like C right now...

Use Array#transpose.