Article ID: 198528
Article Last Modified on 3/14/2005
Dim conn As Object, rs As Object
Dim myArray As Variant
Set conn = CreateObject("ADODB.Connection")
conn.open ("DSN=Test")
Set rs = conn.Execute("select * from test1")
myArray = rs.getrows(1000)
' uncomment the following line to receive correct value in MsgBox.
'myArray = rs.getrows(100)
MsgBox rs("c1")
rs.Close
Set rs = Nothing
conn.Close
Set conn = Nothing
Keywords: kbbug kbfix kbmdac250fix kbado210fix KB198528