I need a table in my application so i am using a recordset that i create myself (by appending fields to the fields collection) - because the fields in the table have different datatypes (strings, ints, singles)

One of the fields that i want to include in the table is actually an array (variable length) of singles.

Does anyone know how i can add a field as an array to a recordset? I've tried using the "adArray" and "adUserDefined" constants for the Type of fields. I've since learned that adArray is in the msdn documentation but does not actually exist.

I'll be really interested if anyone can think of a good way to do this.

Mark,