update matching records

[Aussie John]

HI not sure what Im doing wrong. If I import a file and update matching records (using match field) and select add remaining data as new records it ends up adding all as new records ie doubling my records. Strangely it doesn't always do this if I test just a few records. Is there a bug?

[bruceR]

Most likely a bug in your data. For instance, an extra space at the end of match fields on one side would give you the result you describe.

[comment]

Are you sure the matching records are found before importing?

[Aussie John]

yes thanks there was a bug in the data.