Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 data import wizard does not support line ends in fields | Excel Discussion (Misc queries) | |||
Import a txt file with text fields that have meaningful leading sp | Excel Discussion (Misc queries) | |||
Missing fields when I import from Access to Excel... | New Users to Excel | |||
I'm trying to import fields from one Excel file to another | Excel Worksheet Functions | |||
import specific fields only from excel to database | Excel Discussion (Misc queries) |