Excel IMPORT which updates fields


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>
 
Ad

Advertisements


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

Top