I have programming experience with other languages and am aware of recordsets, but rather than using recordset commands, can I read a table into a dimensioned array. ?
Yes, you can do this. However you would need to instantiate a recordset to pull the initial data before dumping it to an array. Recordsets are very easily to manipulate and provide all of the functions of a normal "array", so I'm not sure why you would want to do this, but it's possible.