i have a csv file. I read that csv in a recordset using the following code:

recordset = CreateObject("ADODB.Recordset")
recordset.Fields.append("F", 200, 255)
recordset.Fields.append("P", 200, 255)
recordset.open()
....
....
recordset.AddNew()
recordset("F") = arrText(0)
recordset("P") = arrText(1)
....
....


what i want is to create two other recordsets and put in there from the original recordset (query)

Dim rs = CreateObject("ADODB.recordset")
Dim Sql = "SELECT * FROM [table]"
rs.Open(Sql, csvrecordset)
MsgBox(rs.Recordcount)
rs.Close()

and then again with a different query to the third recordset.

i think it can be done this way. . but how can i define [table] in my original recordset?