Is it possible to open an instance of a recordset without it having a specific connection.

I then need to load the recordset from an array (got that bit sorted) and then use it as a source in an SQL statement to populate a table in an access database.

VB seems to hint at being able to do this but I can't find any definative syntax info.

This time I searched before I posted but the law of Sod applies.

Thanks in advance