title: Transform XML inputs (files) to ACCESS outputs (table) using XSL
body: <p>I want to transform XML inputs (files) to ACCESS outputs (table) using XSL.
  The XML files I have looks like this :</p>
  
  <pre><code>&lt;?xml version="1.0"?&gt;
  &lt;ZBE14_OEMs_ItemUpdate_IN&gt;
      &lt;Record&gt;
          &lt;Header&gt;
              &lt;HEAD&gt;HEADOEM&lt;/HEAD&gt;
          &lt;/Header&gt;
              &lt;ItemMaster&gt;
                  &lt;CONO&gt;800&lt;/CONO&gt;
                  &lt;WHLO&gt;CA&lt;/WHLO&gt;
                  &lt;STAT&gt;20&lt;/STAT&gt;
                  &lt;ITNO&gt;PNA&lt;/ITNO&gt;
                  &lt;SPE3&gt;SPE3 A&lt;/SPE3&gt;
                  &lt;FRE3&gt;N&lt;/FRE3&gt;
                  &lt;UNNN&gt;HAZ B&lt;/UNNN&gt;
                  &lt;HAC1/&gt;
                  &lt;HAC2/&gt;
                  &lt;ITGR&gt;BAAEAA&lt;/ITGR&gt;
                  &lt;SPE5/&gt;
                  &lt;CSNO&gt;123&lt;/CSNO&gt;
                  &lt;UNMS&gt;AA&lt;/UNMS&gt;
              &lt;/ItemMaster&gt;
          &lt;Trailer&gt;
              &lt;TRAIL&gt;TRAILOEM&lt;/TRAIL&gt;
          &lt;/Trailer&gt;
      &lt;/Record&gt;
      &lt;Record&gt;
          &lt;Header&gt;
              &lt;HEAD&gt;HEADOEM&lt;/HEAD&gt;
          &lt;/Header&gt;
              &lt;ItemMaster&gt;
                  &lt;CONO&gt;800&lt;/CONO&gt;
                  &lt;WHLO&gt;CB&lt;/WHLO&gt;
                  &lt;STAT&gt;20&lt;/STAT&gt;
                  &lt;ITNO&gt;PNB&lt;/ITNO&gt;
                  &lt;SPE3&gt;SPE3 B&lt;/SPE3&gt;
                  &lt;FRE3&gt;N&lt;/FRE3&gt;
                  &lt;UNNN&gt;HAZ A&lt;/UNNN&gt;
                  &lt;HAC1/&gt;
                  &lt;HAC2/&gt;
                  &lt;ITGR&gt;BAAEAA&lt;/ITGR&gt;
                  &lt;SPE5/&gt;
                  &lt;CSNO&gt;456&lt;/CSNO&gt;
                  &lt;UNMS&gt;BB&lt;/UNMS&gt;
              &lt;/ItemMaster&gt;
          &lt;Trailer&gt;
              &lt;TRAIL&gt;TRAILOEM&lt;/TRAIL&gt;
          &lt;/Trailer&gt;
      &lt;/Record&gt;
  &lt;/ZBE14_OEMs_ItemUpdate_IN&gt;
  </code></pre>
  
  <p>What interested me is getting all the data in the <code>&lt;ItemMaster&gt;</code> section.
  I don't know how to do this because the "Header" and "Trailer" tags bother me.</p>
  
  <p>That's what I've managed to do so far:</p>
  
  <pre><code>&lt;xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"&gt;
  &lt;xsl:output omit-xml-declaration="yes" indent="yes"/&gt;
  &lt;xsl:strip-space elements="*"/&gt;
  
  &lt;xsl:template match="node()|@*"&gt;
      &lt;xsl:copy&gt;
          &lt;xsl:apply-templates select="node()|@*"/&gt;
      &lt;/xsl:copy&gt;
  &lt;/xsl:template&gt;
  
  &lt;xsl:template match="ZBE14_OEMs_ItemUpdate_IN/Record/Header/HEAD/ItemMaster/"&gt;
      &lt;xsl:copy&gt;
          &lt;xsl:apply-templates select="@*" /&gt;
      &lt;/xsl:copy&gt;
  &lt;/xsl:template&gt;
  
  &lt;/xsl:stylesheet&gt;
  </code></pre>
  
  <p>Of course, that doesn't work, I'm really a beginner in XSL, so if you guys could help me, that would be much appreciated.</p>
  
  <p>Thank you very much.</p>