G
Greg Roberts
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>
<NAME>CPU</NAME>
<AREA>1</AREA>
</Trend>
<Trend>
<NAME>LOOP_1_PV</NAME>
<AREA>2</AREA>
</Trend>
</rows>
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>
<NAME>CPU</NAME>
<AREA>1</AREA>
</Trend>
<Trend>
<NAME>LOOP_1_PV</NAME>
<AREA>2</AREA>
</Trend>
</rows>