Is There a Way to Convert an Array to a Recordset?

[tfayer]

If I use the Split Function on the string "one two thre", Is there a way to to create a RecordsetSet with the records:

one
two
three

Then If I wanted to refer to the record "one" how would I do that. I have tried.

Debug.Print rs.Item(1)

and it says Method or Data member not found.

Thanks

 

[Frink]

Hallo,

As far as I'm aware recordsets have to be based on tables or queries and the like, so the answer to your first question is no.

To create an array to hold strings, use:

private const cintMaxItems as integer = 10
dim strItem(1 to cintMaxItems) as string

'I'm not familiar with the split function, but you can refer
'to the elements using strItem(<index>), ie.
strItem(1) = &quot;one&quot;
strItem(2) = &quot;two&quot;
strItem(3) = &quot;three&quot;
dim i as integer
for i = 1 to 3
  debug.print strItem(i)
next i

Hope that helps,

- Frink