Hello Guys,

I would like you to help me in a query which can be run when importing excel file with column E-mail.
The importing excel file should be successful, only if the E-mail column has <username>@<****.com>, and it should throw an error "E-mail id is not updated perfectly" if the E-mail column in excel file only contains <username>

I tried my best to write a query on this using "not like" in ms access query but it did not work.

Please, help me to find a solution :-)