Excel IMPORT which updates fields


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

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 ?


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" ?>


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