title: Importing XML into Access with an XSL transform
body: <p>I've seen a few other answers for similar answers, but I can't quite wrap my head around it. I have an attribute centric XML file that I need to import into Access, which will only accept element centric formatting. It seems like I need to do a transform with an XSL file, but I'm not clear how to do it. Since the data is proprietary, I've disguised it with a sci fi theme. What I need to do is turn the first code example into the same format as the second one:</p>
  
  <pre><code>&lt;PLANETARY Protocol="Solar 1"&gt;
    &lt;COLONIES&gt;
          &lt;COLONYDATA site="10001" planet="Mars"&gt;
              &lt;RESOURCEDATA resource="RadiationDanger" value="Low" /&gt;
              &lt;RESOURCEDATA resource="ApplicantColonists" value="11" /&gt;
              &lt;RESOURCEDATA resource="AcceptedColonists" value="3" /&gt;
          &lt;/COLONYDATA&gt;
          &lt;COLONYDATA site="10002" planet="Mars"&gt;
              &lt;RESOURCEDATA resource="RadiationDanger" value="Low" /&gt;
              &lt;RESOURCEDATA resource="ApplicantColonists" value="7" /&gt;
              &lt;RESOURCEDATA resource="AcceptedColonists" value="1" /&gt;
          &lt;/COLONYDATA&gt;
          &lt;COLONYDATA site="11019" planet="Titan"&gt;
              &lt;RESOURCEDATA resource="RadiationDanger" value="Low" /&gt;
              &lt;RESOURCEDATA resource="ApplicantColonists" value="22" /&gt;
              &lt;RESOURCEDATA resource="AcceptedColonists" value="16" /&gt;
          &lt;/COLONYDATA&gt;
      &lt;/COLONIES&gt;
    &lt;/PLANETARY&gt;
  
  
  &lt;Protocol&gt;
  Solar1
      &lt;COLONIES&gt;
          &lt;COLONYDATA&gt;
              &lt;site&gt;10001&lt;/site&gt;
              &lt;planet&gt;Mars&lt;/planet&gt;
              &lt;RadiationDanger&gt;Low&lt;/RadiationDanger&gt;
              &lt;ApplicantColonists&gt;11&lt;/ApplicantColonists&gt;
              &lt;AcceptedColonists&gt;3&lt;/AcceptedColonists&gt;
          &lt;/COLONYDATA&gt;
          &lt;COLONYDATA&gt;
              &lt;site&gt;10002&lt;/site&gt;
              &lt;planet&gt;Mars&lt;/planet&gt;
              &lt;RadiationDanger&gt;Low&lt;/RadiationDanger&gt;
              &lt;ApplicantColonists&gt;7&lt;/ApplicantColonists&gt;
              &lt;AcceptedColonists&gt;1&lt;/AcceptedColonists&gt;
          &lt;/COLONYDATA&gt;
          &lt;COLONYDATA&gt;
              &lt;site&gt;11019&lt;/site&gt;
              &lt;planet&gt;Titan&lt;/planet&gt;
              &lt;RadiationDanger&gt;Low&lt;/RadiationDanger&gt;
              &lt;ApplicantColonists&gt;22&lt;/ApplicantColonists&gt;
              &lt;AcceptedColonists&gt;16&lt;/AcceptedColonists&gt;
          &lt;/COLONYDATA&gt;
      &lt;/COLONIES&gt;
  &lt;/Protocol&gt;
  </code></pre>
  
  <p>Any help would be appreciated. Thanks!</p>