henrik_ahlgren Posted February 27, 2002 Share Posted February 27, 2002 Can someone please explain what I do wrong! I have a FM Pro 5 database with six fields. I import data from Excellsheets and there can be doubles in them. My thought was to use the option "Update matching records and add new records" in the FM Importfunction and set the match one three fields which should capture the doubles and update the record if the three fields alla matched and then add all the rest. But this doesn Link to comment Share on other sites More sharing options...
Kurt Knippel Posted February 27, 2002 Share Posted February 27, 2002 What consitiutes a matching record? Link to comment Share on other sites More sharing options...
henrik_ahlgren Posted February 28, 2002 Author Share Posted February 28, 2002 My thought is that a matching record constitutes of exactly the same contents in all the three fields I put as matching criterias and then three other fields. If there is a match the record is updated and not added to the records, but if there isn Link to comment Share on other sites More sharing options...
Fitch Posted February 28, 2002 Share Posted February 28, 2002 It would help to know what you mean by, "But this doesn Link to comment Share on other sites More sharing options...
henrik_ahlgren Posted February 28, 2002 Author Share Posted February 28, 2002 With "But it dosen Link to comment Share on other sites More sharing options...
henrik_ahlgren Posted February 28, 2002 Author Share Posted February 28, 2002 It works! I think it was a the testtime field that was the problem, maybe because of ane extra space after or something that I couldn Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8091 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