Dim RS As ADODB.Recordset
Dim DataStream As ADODB.Stream
Set RS = cn.open(……)
Set DataStream = New ADODB.Stream
' Save the recordset object as XML into the stream
RS.Save DataStream, adPersistXML
' Read and pass the XML string from the Stream to the
' SoapSerialized object
pSoapSerializer.writeXML DataStream.ReadText
rst.Save FileName:=strFileName, PersistFormat:=adPersistXML
Microsoft ActiveX Data Object 2.0 Library (Not OK)
Microsoft ActiveX Data Object 2.1 Library (OK)
Microsoft ActiveX Data Object 2.5 Library (OK)
Microsoft ActiveX Data Object 2.6 Library (OK)