Results 1 to 2 of 2

append xml data and rename unique id

  1. #1
    DanChirila is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Apr 2012
    Posts
    1

    append xml data and rename unique id

    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 Click image for larger version. 

Name:	relatii.JPG 
Views:	3 
Size:	102.1 KB 
ID:	6973
    here are 2 of my xml files . (sorry for may english)
    Attached Files Attached Files

  2. #2
    June7's Avatar
    June7 is offline Moderator
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    30,640
    To provide db: Make copy, remove confidential data, run compact & repair, zip w/Windows Compression if over 500KB (2MB zip allowed), attach to post. Attachment Manager is below the Advanced post editor window.
    If suggestion in this post resolves your issue, please use the Thread Tools and mark the thread as Solved!

    Debug!Debug!Debug! http://www.cpearson.com/excel/debug.htm

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Unstack Data and Match with Unique ID
    By lukejones in forum Queries
    Replies: 7
    Last Post: 02-24-2014, 06:33 AM
  2. Data append to table
    By ali zaib in forum Access
    Replies: 4
    Last Post: 01-13-2012, 09:22 AM
  3. List box doesn't allow Unique data entries
    By Delta223 in forum Forms
    Replies: 2
    Last Post: 01-24-2011, 05:24 PM
  4. Replies: 0
    Last Post: 01-03-2011, 01:38 PM
  5. Append Checkbox Data
    By jgelpi16 in forum Programming
    Replies: 3
    Last Post: 06-29-2010, 03:58 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums