I have a recordset with a single column, where each cell contains a number of tilda separated values, for example:
| one~two~three |
| four~five~six |
which I want set up into a two dimensional array, ie:
| one | two | three |
| four | five | six |
I keep getting 'Subscript out of range: 'arrArray'' error, and I assume I am doing something fundamentally wrong - can anyone help out please?
Thanks in advance!
If Not(objRefCursor.eof) And Not(objRefCursor.bof) Then
ReDim arrArray(objRefCursor.RecordCount, nColumns)
For nRowCount = 0 To nRows
arrArray(nRowCount) = Split(objRefCursor(nRowCount), "~")