I need to store recordsets to file for future retrieval. Is there a way to serialize recordsets?
Printable View
I need to store recordsets to file for future retrieval. Is there a way to serialize recordsets?
I am assuming you are asking about ADO Recordsets, which has a Save method.
From the help file.
Quote:
Save Method
Saves the Recordset in a file or Stream object.
Syntax
recordset.Save Destination, PersistFormatParameters
Destination
Optional. A Variant that represents the complete path name of the file where the Recordset is to be saved, or a reference to a Stream object.
PersistFormat
Optional. A PersistFormatEnum value that specifies the format in which the Recordset is to be saved (XML or ADTG). The default value is adPersistADTG.