need to update from an XML file

[Rob]

I have a table that I need to update but my new data source is xml but I
don't know how to do it. Luckily both the access and xml are well formatted.

my access table structure is like so

ISBN, shippingweight.
Okay, actually there's more info but this is the only relevant info.

and my XML file is formatted like so
<Product>
<ProductIdentifier>
<ProductIDType>02</ProductIDType>
<IDValue></IDValue> <-this value matches my table ISBN field.
</ProductIdentifier>
<Measure>
<MeasureTypeCode>08</MeasureTypeCode>
<Measurement>2.4800</Measurement> <-weight
<MeasureUnitCode>lb</MeasureUnitCode>
</Measure>
</Product>

My access table does not have any values for weight if that makes any
difference. Also, the xml file has other Measure fields as well, but
MeasureTypeCode 08 is the only one I need since that is for weight and the
others are product dimensions. All weights are in pounds.

I have tried importing the xml but it creates a table for each element in
the XML file.

 

[Rob]

I still need help with this. or directly. The solution doesn't have to be
free.

 

[susiedba]

you should use a real tool like SQL Server instead of a piece of crap
database engine like MDB format.

SQL Server has REAL TOOLS for mixing DATA and XML

-Aaron

 

[Brendan Reynolds]

If you add a reference to Microsoft's XML parser, MSXML, you can use its
properties and methods to read an XML file. Look for MSXML documentation at
MSDN (http://msdn.microsoft.com/xml/). There's also an XML newsgroup,
microsoft.public.xml, where you can ask questions if you get stuck. There's
a link to the newsgroup from the Web page above.

 

[Rob]

Thanks for the info Brendan. I'll check it out. I just figured this would be
the better forum because the destination is access.

 

[Brendan Reynolds]

I wasn't suggesting that this was the wrong forum for the original question,
Rob. Just that the XML newsgroup would be a good place to ask any future
questions you might have about using the XML parser.