recordset that not connect to DB

[royi]

How can I create a recordset that is not!! connected to the db but I by myself want to add columns and rows to this recordset.

For example ADODB.Recordset is connected to db according
to source that I previuosly defined. The question is if there is any rs that does not connect to the db.

Thank you,
Roy

[paulw]

Yes, you can do this.

ADO has support for stand-alone and file-based recordsets.

Dim rs As New ADODB.Recordset
rs.Fields.Append "FirstField", adChar, 40 etc...
rs.Fields.Append.....
rs.Open
rs.AddNew etc.

Note that you can define data types and data options (adFldIsNullable etc.)

You can use this technique to read file based data into your recordset (or Arrays, or UDTs or HTML or whatever!)

Hope that helps...

Paul.