require 'win32ole'
conn = WIN32OLE.new('ADODB.Connection')
strCnxn="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=f:\\My Documents\\db1.mdb;Persist Security Info=False"
conn.Open strCnxn
rsCustomers = WIN32OLE.new("ADODB.Recordset")
strSQLCustomers = "select * from test1"
rsCustomers =conn.execute(strSQLCustomers)
rsCustomers.MoveFirst()
print "test#{rsCustomers.Fields}"
puts rsCustomers.Fields.item('test').value # field value
puts rsCustomers.Fields.item('test').name #field name
puts rsCustomers.Fields.Count
