I need a simple validation rule to make sure that data conforms to this
format:letter letter letter number number number number. ive tried all
the obvious codes eg like"lll9999" but Access refuses to import any
data at all.it doesnt even generate an error table for me to look at.
help me please im using access 2003 many thaks

oiref wrote:

I need a simple validation rule to make sure that data conforms to this
format:letter letter letter number number number number. ive tried all
the obvious codes eg like"lll9999" but Access refuses to import any
data at all.it doesnt even generate an error table for me to look at.
help me please im using access 2003 many thaks

I'm assuming you mean a table validation rule. The following should
work:

Like "[A-z][A-z][A-z]####"

Bruce