MS access query to avoid importing excel file which does not include @***.com
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 :-)
Re: MS access query to avoid importing excel file which does not include @***.com
Why not make the query criteria *@* so it would look for that mask in the field.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By JessicaW in forum Excel Programming / VBA / Macros
Last Post: 01-04-2013, 02:51 PM
By Excel Eejit in forum Excel General
Last Post: 07-01-2011, 02:48 PM
By disturbedfan1 in forum Excel Programming / VBA / Macros
Last Post: 09-10-2010, 11:33 AM
By bromero in forum Excel General
Last Post: 02-17-2010, 01:15 PM
By ge0rge in forum Excel General
Last Post: 04-02-2009, 10:51 AM
Tags for this Thread
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1