Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

XML Import To Access - Overwrite Issue

Status
Not open for further replies.

wipers123

Technical User
Feb 11, 2010
1
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?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top