I want the xml like

<root>
    <client>
        <name value="5"> sam </name>

    </client>
    <vendor>
        <name value="7"> sam </name>

    </vendor>
</root


plz tel me hoe to write the xls for this format .

<?xml version="1.0" encoding="utf-8"?>

<xsl:stylesheet version="1.0"
    xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

<xsl:template match="/">
  <root>
    <client>
        <name value="5"> sam </name>
    </client>
    <vendor>
        <name value="7"> sam </name>
    </vendor>
</root>
</xsl:template>
</xsl:stylesheet>


--

Joe (Microsoft MVP - XML)