Export Data from ADO Recordsets to XML
If you'd like to do this using ADO 2.5, see http://www.freevbcode.com/ShowCode.Asp?ID=1204. The advantage of using ADO is that you will be able to load the saved XML file back into a recordset object.
Instructions: Click the link below to download the code. Select 'Save' from the IE popup dialog. Once downloaded, open the .zip file from your local drive using WinZip or a comparable program to view the contents.