William James wrote:

>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.
>  
>
Good. I really did search and search before writing my own - and there 
you go, I just didn't look properly.
I'm so glad I always ask.