title: How to convert attribute xml to element xml for import in Access without loosing data
body: <p>I am new to xml and xsl so I'll try to explain my problem.
  I have this type of xml, it is attribute centric and those doesn't import into Access. How to convert attribute data to element data?
  Here is a part of xml I have:</p>
  
  <pre><code>&lt;?xml version="1.0" encoding="ISO-8859-1"?&gt;
  &lt;Catalogue version="3.0"&gt;
  &lt;App action="A" id="1"&gt;
      &lt;BaseVehicle id="1"/&gt;
      &lt;Note&gt;Use Separate Enclosed Connector&lt;/Note&gt;
      &lt;Note&gt;Slightly longer than original&lt;/Note&gt;
      &lt;Qty&gt;1&lt;/Qty&gt;
      &lt;PartType id="8852"/&gt;
      &lt;MfrLabel&gt;CleanWipe&lt;/MfrLabel&gt;
      &lt;Position id="104"/&gt;
      &lt;Part&gt;18CW&lt;/Part&gt;
  &lt;/App&gt;
  &lt;App action="A" id="2"&gt;
      &lt;BaseVehicle id="1"/&gt;
      &lt;BodyType id="6"/&gt;
      &lt;Note&gt;Use Separate Enclosed Connector&lt;/Note&gt;
      &lt;Qty&gt;1&lt;/Qty&gt;
      &lt;PartType id="8852"/&gt;
      &lt;MfrLabel&gt;SuperWipe&lt;/MfrLabel&gt;
      &lt;Position id="30"/&gt;
      &lt;Part&gt;22SW&lt;/Part&gt;
  &lt;/App&gt;
  &lt;/Catalogue&gt;
  </code></pre>
  
  <p>This is the xsl I used for importing xml into Access
  (I don't really understand how it works, I found it here on stackflow):</p>
  
  <pre><code>&lt;xsl:stylesheet version="1.0"  xmlns:xsl="http://www.w3.org/1999/XSL/Transform"&gt;
  &lt;xsl:output method="xml" indent="yes"/&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:stylesheet&gt;
  </code></pre>
  
  <p>Problem is I lose App ID. Is there a way to import in Access this data and to have App ID in a column?
  Also I have a problem with "Note" lines, because there are more than one Note line per "App", I couldn't import all Note lines. Do you have a suggestion how to import this xml without losing any data?
  Thank you all!!!</p>
  
  <p>Edit:
  Here is the list I expect after import in Access:</p>
  
  <p>ID  BaseVehicle Note            Qty PartType    MfrLabel    Position    Part    BodyType</p>
  
  <p>1   1           Slightly longer than original   1   8852        CleanWipe   104         18CW<br>
  1   1           Use Separate Enclosed Connector 1   8852        CleanWipe   104         18CW<br>
  2   1           Use Separate Enclosed Connector 1   8852        SuperWipe   30          22SW    6</p>
  
  <p>Or like this:</p>
  
  <p>ID BaseVehicle  Note            Qty PartType    MfrLabel    Position    Part    BodyType</p>
  
  <p>1  1          Slightly longer.. + Use Separate E..  1   8852        CleanWipe   104         18CW<br>
  2  1          Use Separate Enclosed Connector   1   8852        SuperWipe   30          22SW    6</p>
  
  <p>Problem is I cannot make it import column ID and to combine notes or import non-first notes in a separate line...</p>