When importing an XML file, it is overwriting data if there are mulitple lines for that field in one record.

For example:

<App action="A" id="16386">
<BaseVehicle id="30420">2009 BMW 323i</BaseVehicle>
<Note>Remove and discard blade cover.</Note>
<Note>OE Design</Note>
<Qty>1</Qty>
<PartType id="8852">Windshield Wiper Blade</PartType>
<MfrLabel>NeoForm Blade</MfrLabel>
<Position id="12">Right</Position>
<Part>16-1912</Part>
</App>

When importing the above, only the second "Note" appears rather than both. Right now it just imports "OE Design" and not "Remove and discard blade cover." so I'm assuming that the second <note> is overwriting the first. What I need it to be is: "Remove and discard blade cover. OE Design"

Is there a different way for me to import the data into Access that would in essence "concatenate" these notes, showing all of the notes in one field? My final database can only have one note field and the XML file is supplied to be from an outside source (so I can't really build the file differently). How do I get all notes to appear in the one note field?