Excel IMPORT which updates fields
 

I have data in a DBF file which can be viewed and edited in Excel.

An application can modify some some of this data downstream but does not
have direct access to the DBF file. I can produce a CSV or XML file with
changes.

I want to import a CSV or XML file which contains a few records with some
modified fields into EXCEL and have the fields updated.

= No matter what options i use in Excel 2007 IMPORT i end up with new
fields / records and cannot update the original fields.

= Can someone suggest the method to make this work ?

Thanks

e.g. XML example

The DBF has say 20 columns and 1000 rows. The XML has just a couple of items
and updates to a couple of columns.

<?xml version="1.0" ?
<rows
<Trend
<NAMECPU</NAME
<AREA1</AREA
</Trend
<Trend
<NAMELOOP_1_PV</NAME
<AREA2</AREA
</Trend
</rows