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
|