Newbies mireille Posted April 19, 2002 Newbies Share Posted April 19, 2002 I want to import/update records from one file (dbase A) to another (dbase :, matching on names. The problem is that in the case of empty fields in the records that are updated (dbase A), the data from that field in dbase B are lost, thus overwrited with the empty field of A. How can I maintain data in B if the field in A is empty? Mireille Link to comment Share on other sites More sharing options...
IdealData Posted April 19, 2002 Share Posted April 19, 2002 Why not do this by a script and use the Set Field command only if the field in fileA has a value. You will need a relationship to match with and the process will be slower the direct import - but you get the control you are looking for Link to comment Share on other sites More sharing options...
LiveOak Posted April 29, 2002 Share Posted April 29, 2002 If you use a lookup to update the data, you can specify "do not copy" if the field in the file copied from is empty. -bd Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7633 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now