Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 data import wizard does not support line ends in fields ChrisLime Excel Discussion (Misc queries) 0 February 25th 09 01:07 PM
Import a txt file with text fields that have meaningful leading sp Muehe Excel Discussion (Misc queries) 2 April 3rd 08 11:48 PM
Missing fields when I import from Access to Excel... AAOO (Sean) New Users to Excel 2 November 4th 06 11:38 PM
I'm trying to import fields from one Excel file to another Angel Incognito Excel Worksheet Functions 1 November 2nd 06 11:09 PM
import specific fields only from excel to database [email protected] Excel Discussion (Misc queries) 0 August 26th 06 10:26 AM


All times are GMT +1. The time now is 06:42 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"