Solved

MS Access or MS Excel Query to select only rows with a specific keyword in a column

Posted on 2013-01-15
2
299 Views
Last Modified: 2013-03-16
Hi, I have an excel list with 5,000 records. I need to isolate records from this list based on a keyword value in a specific column.

For example, the client might request we isolate records if a recipient has the keyword "teacher" in the "title" column. A recipient might have "Senior Teacher" or "math teacher", etc for their title.

Can anyone point me to a query  / method I can easily use in MS Excel 2007 or MS Access 2007?

Thanks
0
Comment
Question by:Mark B
2 Comments
 
LVL 119

Accepted Solution

by:
Rey Obrero earned 500 total points
ID: 38780144
you can either import or link to the Excel file from Access

External Data > Import > excel
follow the wizard


after you link or imported the Excel file

create a query like this

select * from TableExcel
where [Title] Not Like "*teacher*"

to show all records with teachers on ttheir Title

select * from TableExcel
where [Title]  Like "*teacher*"
0
 
LVL 18

Expert Comment

by:krishnakrkc
ID: 38781488
In Excel, Goto Data > Filter > Text Filters > Does Not Contain > "Teacher" (without quotes)

Kris
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Recently Microsoft released a brand new function called CONCAT. It's supposed to replace its predecessor CONCATENATE. But how does it work? And what's new? In this article, we take a closer look at all of this - we even included an exercise file for…
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now