title: Export XML from MS Access to Import in PowerShell
body: <p><strong>Background</strong></p>
  
  <p>I'd like to export multiple data records from MS Access 2016 to XML, which will be further used to import in PowerShell.</p>
  
  <p>I used different native XML-Export Settings (no VBA so far) but all I got is a Array of strings:</p>
  
  <pre><code>$path = "c:\MsAccessExport.xml"
  $Content = Get-Content $path
  $xml = ConvertTo-Xml -InputObject $Content
  
  $xml.Objects.Object.Property
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/NaeTJ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/NaeTJ.png" alt="enter image description here"></a></p>
  
  <pre><code>PS C:\WINDOWS\system32&gt; ($xml.Objects.Object.Property).GetType()
  
  IsPublic IsSerial Name                                     BaseType
  -------- -------- ----                                     --------
  True     True     Object[]                                 System.Array 
  </code></pre>
  
  <p>If I check the XML in a XML-Viewer / IE, the export doesen't look that bad, meaning I see the parent (<code>HolidaySet</code>) containing a relation to the children (<code>Holidays</code>):
  <a href="https://i.stack.imgur.com/05E9E.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/05E9E.png" alt="enter image description here"></a></p>
  
  <p><strong>Question</strong></p>
  
  <ul>
  <li><p>Is there a way in PowerShell to select/Access the nodes as usuall?</p></li>
  <li><p>If not, is there a way to modify the Export from Access, to make sure PowerShell can Read it proberly?</p></li>
  </ul>