title: Importing XML files into an Access DB with multiple tables
body: <p>I have a bunch of (flat) XML files such as:</p>
  
  <pre><code>&lt;?xml version="1.0" encoding="UTF-8"?&gt;
  &lt;SomeName&gt;   
    &lt;UID&gt;
      ID123
    &lt;/UID&gt;
    &lt;Node1&gt; 
      DataA 
   &lt;/Node1&gt;   
   &lt;Node2&gt; 
      DataB 
   &lt;/Node2&gt;   
    &lt;Node3&gt; 
      DataC 
   &lt;/Node3&gt;   
    &lt;AnotherNode1&gt; 
      DataD 
   &lt;/AnotherNode1&gt; 
    &lt;AnotherNode2&gt; 
      DataE 
   &lt;/AnotherNode2&gt; 
    &lt;AnotherNode3&gt; 
      DataF 
   &lt;/AnotherNode3&gt; 
   &lt;SingleNode&gt; 
      DataG 
   &lt;/SingleNode&gt; 
  &lt;/SomeName&gt;   
  </code></pre>
  
  <p>Now my actual XML files have too many nodes, so they can't be imported into a single table (due to the 255 column limit), so I need to split the data into multiple tables. I already created the tables by hand so now all access would have to do is match the Node names with the columns in each of the tables and copy the data.</p>
  
  <p>It does so only for one table named 'SomeName', but leaves all other tables untouched.</p>
  
  <p>I am unsure of how to get access to import my XML files properly into all the tables. I also already tried creating the UID field in each table and linking them (since the UID is unique to each XML dataset), but that left access unimpressed as well.</p>
  
  <p>I've tried to find any sort of info on this problem, but have so far found nothing.</p>
  
  <p>I would very grateful for any help or pointers.</p>