I want to store and restore recordsets as XML? I know ADO 2.1 has this
However, what I'd like to do is craft a recordset by hand, save it as XML
but not as an external file on disk but to a string/variant property (I'm
using VB6, and Excel 97/2000) which I will subsequently store inside an
Excel .XLS file.
Can you tell me if ADO only supports writing to, and reading from, a disk
bound file containing a persisted recordset?
If so, I guess I'm going to have to save the recordset to a hidden XML file
on disk, read the contents of that file into a string, delete the disk file;
and when re-constituting the XML, save the XML string inside the Excel file
to a disk file, get ADO to read it, and then delete it.