How do I merge data into approach...when I import it creates a new rec
How do I merge data into approach...when I import it creates a new rec
(OP)
What is the best way to merge data in approach? I'm tracking software version year over year. I have one file listing servers and software application with our version in January 2007. I need to merge the version we had in 2006.
Ideally I'd like
Server SW Application 2006 Version 2007 Version
BLUE Tivoli 1.0 1.5
But what I get is 2 records....
Server SW Application 2006 Version 2007 Version
BLUE Tivoli 1.5
BLUE Tivoli 1.0
Ideally I'd like
Server SW Application 2006 Version 2007 Version
BLUE Tivoli 1.0 1.5
But what I get is 2 records....
Server SW Application 2006 Version 2007 Version
BLUE Tivoli 1.5
BLUE Tivoli 1.0
RE: How do I merge data into approach...when I import it creates a new rec
A .dbf file can be used to add and update records -- you match up on one or more fields for the update option.
Sue Sloan