How Validate the values in list

[ccguillermo]

HI;
I want to validate the value of the list in the lookup in the table and create a list of the values that no match the values of the list..

Thank you

Carlos

 

[JHB]

What about creating an unmatched query instead.
Use the Query Wizard.

 

[ccguillermo]

hi;
Thank you Jhb. but now I more clear what I am looking for:
I try to import from excel to Access a big tables but I need to validate some fields like Laguage(Armenian, English, Spanish Russian, Chinese) it is the values in the Value list in the table. by mistake in excel some body type Italian an it is no in Value list. It is the problems that i want to fixed. How I can create a list of error in access like this with the ID that is in the table and the field where is the error and fix later in the form for this table. with the error list I talk about many record in the excel or any another idea how to approch this problem.
Thank you..

 

[JHB]

I would still say, create an unmatched query.
If you could post some sample data in Excel or MS-Access + the table with the language.