upsizing access to sql server

[hfs]

I have moved my database to sql server, but a memo field which should be unique ,when goes into sql server does not have unique records..I tried using this code

CREATE UNIQUE INDEX UIX_YourIndexNamheHere
ON dbo.tblExcelLocation(ExcelPathLocation)
WITH (IGNORE_DUP_KEY = ON);

but its of no use ....
the field is not unique still,,
any ideas?

 

[hfs]

any body ?:banghead: