Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    May 2003
    Location
    Grand Rapids, Michigan, USA
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Import from XML - multiple layers (Access XP)

    <img src=/S/drop.gif border=0 alt=drop width=23 height=23> I've got an XML file to import to Access, into 3 separate, linked tables. If I just do a File, Get External Data, Import, it imports the data into the tables, but there are NO relationships between the data.

    Here's my sample XML:

    - <IIABA>
    - <Event>
    <EventID>63</EventID>
    <StateEventID />
    <EventName>CIC - Personal Lines October 2003</EventName>
    <EventDescription>CIC Enrollment</EventDescription>
    <EventStatus>Open</EventStatus>
    - <Participant>
    <nationalMembershipNumber>313624</nationalMembershipNumber>
    <FirstName>Scott</FirstName>
    <LastName>Heaney</LastName>
    - <LineItem>
    <LineItemID>104</LineItemID>
    <LineItemName>CIC - Personal Lines</LineItemName>
    <UnitAmount>345.0000</UnitAmount>
    <UnitCount>1</UnitCount>
    <LineItemTotal>345.0000</LineItemTotal>
    </LineItem>
    </Participant>
    - <Participant>
    <nationalMembershipNumber>358252</nationalMembershipNumber>
    <FirstName>Laraine</FirstName>
    <LastName>Sakamoto</LastName>
    - <LineItem>
    <LineItemID>104</LineItemID>
    <LineItemName>CIC - Personal Lines</LineItemName>
    <UnitAmount>345.0000</UnitAmount>
    <UnitCount>1</UnitCount>
    <LineItemTotal>345.0000</LineItemTotal>
    </LineItem>
    </Participant>
    </Event>
    - <Event>
    <EventID>149</EventID>
    <StateEventID />
    <EventName>CISR - Personal Auto, 11/6/03</EventName>
    <EventDescription>CISR - Personal Auto, 11/6/03</EventDescription>
    <EventStatus>Open</EventStatus>
    </Event>
    </IIABA>


    Thanks in Advance.

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Import from XML - multiple layers (Access XP)

    Unless I've missed something, I don't see any relationships in the XML code - Access needs those in order to establish relationships. Try creating the relationships in Access, and then export the data to XML and see if it provides the required keywords.
    Wendell

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •