The Save method saves a Recordset object to a file or a Stream object. When
the save method is finished, the record pointer will point at the first record
of the Recordset.
Note: If there is a filter applied to the Recordset, only the
"filtered" records will be saved.
Note: This method can only be called on an open Recordset.
Syntax
objRecordset.Save destination,persistformat
Parameter
Description
destination
Optional. Specifies where to save the Recordset object;
the
path name of a file or a reference to a Stream object
persistformat
Optional. A
PersistFormatEnum value that specifies the format of the Recordset (XML or
ADTG). Default is adPersistADTG
Example
You can save a Recordset in XML format:
<%
set xmlDoc=CreateObject("Microsoft.XMLDOM")
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open "c:/webdata/northwind.mdb"
set rs = Server.CreateObject("ADODB.recordset")
rs.Open "Customers", conn
'Save the Recordset into a DOM tree
rs.Save xmldoc, 1
%>
W3Schools is for training only. We do not warrant its correctness or its fitness for use.
The risk of using it remains entirely with the user. While using this site, you agree to have read and accepted our
terms of use and
privacy policy.