Hi Everyone,
I am trying to import XML into access however have noticed that Access 2013 is not importing fields/parameters found within tags. For example:
<locations>
<locationelement description="Master Location" dns="tester.test.com" key="M0" lastupdated="Never Updated" pdport="5555" port="5551">
<monitoringperiodtimezone>EST5EDT</monitoringperiodtimezone>
<monitoringperiod days="Sunday" hours="28-95" />
<monitoringperiod days="Monday,Tuesday,Wednesday,Thursday,Friday,Saturday" hours="all" />
</locationelement>
</locations>
When importing, Access creates a table locationelement with fields for monitoringperiodtimezone (containing EST5EDT) and monitoringperiod (containing nothing). I was wondering if there is a way to access fields such as description, dns, key etc or days, hours, ie fields that are within a tag.
Any help will be greatly appreciated.