+ Reply to Thread
Results 1 to 3 of 3

Wild cards in MSQuery

  1. #1
    Forum Contributor
    Join Date
    03-30-2010
    Location
    Manchester England
    MS-Off Ver
    Excel 2010
    Posts
    992

    Wild cards in MSQuery

    I have a table that I am querying with MSQuery. It has a field NAMES that has a group of entries like "Do not use", "Do no use" "Do not use, Delete?" and other misspellings of these.

    I am hoping I can leave these behind by using syntax like <> Like 'Do not use %' In the criteria field of NAMES. I have tried many versions of this after reading the ms help files but I always get "Syntax error" If I just use <>"Do not use" the query works. Can somebody help me get it right?
    John

  2. #2
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent Monthly Channel / Insiders Beta
    Posts
    8,903

    Re: Wild cards in MSQuery

    You need NOT Like rather than <> Like
    Rory

  3. #3
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,516

    Re: Wild cards in MSQuery

    Exclude?

    Perhaps

    Where Not `Name` Like 'blabla%'

    Or

    Where (`SheetName$`.Name Not Like 'blabla%')
    Last edited by jindon; 07-17-2019 at 09:05 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Can I Use Wild Cards?
    By rblassit in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-16-2012, 11:50 AM
  2. Wild cards?
    By bobbych in forum Excel General
    Replies: 2
    Last Post: 05-17-2012, 07:11 AM
  3. If Statement Using Wild Cards
    By Adrian M in forum Excel Formulas & Functions
    Replies: 20
    Last Post: 09-06-2005, 05:05 PM
  4. If Statement Using Wild Cards
    By Jasmine in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 04:05 PM
  5. [SOLVED] If Statement Using Wild Cards
    By Jasmine in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 PM
  6. If Statement Using Wild Cards
    By Jasmine in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 PM
  7. [SOLVED] If Statement Using Wild Cards
    By Jasmine in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 11:05 AM
  8. Using Wild Cards
    By shellback1998 in forum Excel General
    Replies: 0
    Last Post: 03-29-2005, 03:40 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1