Need help with a Like statement

[itm]

Hi,
I am have an Excel table that I have successfully imported in to a table, How ever the last few lines will always have heading information that will always be the same. One line starts with "Client", the 2nd line starts with "Confidential" and the third line starts with "Generated". So I figured that I could look for these and just delete lines that start with these words. However, nothing that I have done so far works.
If anyone has an idea I would appreciate it.
Thank you


Here is my code:

SELECT Left(tblTemp_Import_File.ID,6) AS test
FROM tblTemp_Import_File
WHERE tblTemp_Import_File.[ID] Like ("Client%") Or Like ("Confidential%") Or Like ("Generated%") Or Like ("Meritain%");

[JoeM]

How about:

WHERE LEFT(tblTemp_Import_File.[ID],6) Not In ("Client","Confid","Genera","Merita");

This will exclude any record where the ID field begins with any of these first 6 letters.

[itm]

Hi,
Thaks, but unfortuantly that returns thouse rows and all the other rows as well.

[itm]

Sorry that did work I had to refresh.
Thank you
I really appreciate your help