Import XML File - Field Overwrite Issue

W

Wipers123

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Import XML file to Access 2007 2
Note's font and File As order... 3
Import XML Data 0
My Client is looking for a .Net Developer with Coding Experience... 0
A really big challenge (for me at least) - XML File Import into DB 4
WebDav - Outlook Contact Notes Field 1
Business Contact Mgr - reposting: Data loss and history list issue 0
DOWNLOAD GibbsCAM 2009,Autocad 2009,WILCOM 2009,CAMWORKS 2009,CATIA2009,Medical software,MASTERCAM X 0

Top