Unique Index

[hansdbase]

I have a seemingly strange problem. I have a table where the name field is not the pk but it is designed to be unique. When I try to add a duplicate name in the table, it won't permit it. When I try to add a duplicate name in a form for this table, it won't allow it. That is good. But when I append data to the table from an excel spreadsheet, it puts in duplicate names. I am not sure how this is occuring and why the unique index is allowing it. Any ideas?

[NoellaG]

Check if it are real duplicates, or the name seems the same but contains extra spaces