In excel I often grab a range of cells and put them into a matrix for futher use.
In Access, I use a macro like the attached UDF.
But, it occured to me that there might be an easier way and a better way to do it.
Does anybody have any comments?
Function RsToArray(rs As DAO.Recordset)
dim1ubound = rs.RecordCount
dim2ubound = rs.Fields.Count
ReDim myArray(0 To dim1ubound, 0 To dim2ubound - 1)
For i1 = 0 To dim1ubound
For i2 = 0 To dim2ubound - 1
myArray(i1, i2) = rs(i2)
RsToArray = myArray