One of the features of the ADO Recordset is that it can be created manually. Instead of creating a recordset by way of a database, you can create a recordset, add fields to it of various types, and then add data to it. You can then manipulate it just like a database-created one, save it to disk, or pass it back from a component for use in an application.

After you create the recordset object, you can use the Add method of the Fields collection to create new fields for your recordset. When you create these fields, you can specify the data type, the field length, and so on. Once you have the fields added, you can use the Open method to open the recordset for modification. You then use the AddNew method to create a new record, followed by the Update method to commit the record to the recordset. Refer to the ADO Fields collection for more information about this feature.