ADO provides a new shorthand method to create a Recordset by appending new Field objects to the Fields collection of a Recordset. Later, you can open the Recordset and insert data from any source—not necessarily a database—into it. You can also manufacture the data programmatically.
The new Recordset can employ all the data manipulation methods available to any Recordset. Use the Recordset to supply information to a visual control, or even to update an actual data source.