Input masks and append querries

[DazHAT]

I have a field in a table with the input mask LLL0000;0;_

when I use an append querry to put data in the table it still puts in data which does not follow the input mask. Is there some tick box I have not checked or somthing because this is getting really annoying.

All help really appreciated.

 

[FoFa]

I do not believe input masks pertain to SQL (append query). Only manual input.

 

[DazHAT]

what can I do to make it only import data which is correct.

I know I have done this before and I am pretty sure it will generate another table with the data which can not be entered.