Displaying ADO Recordsets saved as XML with XSL

[mick lennon]

Hi Folks
I use the following to save my heirarchical recordset as XML.

Dim db2 As New adodb.Connection
Dim palletconnstring As String
Set adoRSForXML = New Recordset
palletconnstring = "PROVIDER=MSDataShape;Data PROVIDER=MSDASQL;dsn=mltest;uid=;pwd=;"
db2.Open palletconnstring

adoRSForXML.Open "SHAPE {select palletid,tla,rev,datecreated,MovedToFG,MovedToHUB,HubNAME,Shipped from PalletDetails2 where palletid = '" & Trim(adoPrimaryRS!palletid) & "' Order by palletid} AS ParentCMD APPEND ({select serialno,palletid from Serialno2 Order by serialno } AS ChildCMD RELATE palletid TO palletid) AS ChildCMD", db2, adOpenStatic, adLockOptimistic


adoRSForXML.Save "pallet_serialno.sav", adPersistXML
adoRSForXML.Save s, adPersistXML

I get the attached XML file. I want to be able to create an HTML report at run time using an XSL script.
How do I associate and XSL file with it at run time?
Do I have to add any reference to the XSL file inside the XML file?

Cheers folks