i need some help! i don't have any programing skills an i need to import multiple xml files into an access database. The problem is that xml files have the same unique id values, example:
the first xml file:
<?xml version="1.0" standalone="yes"?>
<CPXML>
<Address>
<ADDRESSID>1</ADDRESSID>
<SIRSUP>32394</SIRSUP>
<SIRUTA>32401</SIRUTA>
<INTRAVILAN>true</INTRAVILAN>
<STREETTYPE>STR</STREETTYPE>
<STREETNAME>CALEA MOLDOVEI</STREETNAME>
<POSTALNUMBER>66</POSTALNUMBER>
<BLOCK />
<ENTRY />
<FLOOR />
<APNO />
<ZIPCODE />
<DESCRIPTION />
<SECTION />
</Address>
<Address>
<ADDRESSID>2</ADDRESSID>
<SIRSUP>35090</SIRSUP>
<SIRUTA>35107</SIRUTA>
<INTRAVILAN>true</INTRAVILAN>
<POSTALNUMBER />
<BLOCK />
<ENTRY />
<FLOOR />
<APNO />
<ZIPCODE />
<DESCRIPTION />
<SECTION />
</Address>
and the second one
<?xml version="1.0" standalone="yes"?>
<CPXML>
<Address>
<ADDRESSID>1</ADDRESSID>
<SIRSUP>34850</SIRSUP>
<SIRUTA>34869</SIRUTA>
<INTRAVILAN>true</INTRAVILAN>
<POSTALNUMBER>7</POSTALNUMBER>
<BLOCK />
<ENTRY />
<FLOOR />
<APNO />
<ZIPCODE />
<DESCRIPTION />
<SECTION />
</Address>
<Address>
<ADDRESSID>2</ADDRESSID>
<SIRSUP>34850</SIRSUP>
<SIRUTA>34869</SIRUTA>
<INTRAVILAN>true</INTRAVILAN>
<POSTALNUMBER>8</POSTALNUMBER>
<BLOCK />
<ENTRY />
<FLOOR />
<APNO />
<ZIPCODE />
<DESCRIPTION />
<SECTION />
</Address>
<Address>
i need to import these xml file and olso keep the relationship betwen tables
here are 2 of my xml files . (sorry for may english)