Using Excel values as criteria? 1

[Lost500]

Hi All!
I would like to use a list of values from an excel spreadsheet as the criteria for a query... i.e. someone has a list of names and wants a report for those specific people. can i use their spreadsheet or do i have to type in each person's name? Please help!

Thanks

 

[lespaul]

you can import the list into a table and then use that as criteria in your query....

Leslie

Come join me at New Mexico Linux Fest!

 

[Lost500]

thanks leslie
and how does one use the values in a table as criteria? sorry for the ignorance but thanks for the help!

 

[Lost500]

sorry i meant how to do that in the query builder?

do you add the table and link it to my real tables and then use the name field from my temp table so that the results will only show linked data from those values? i think thats what your saying right???

is there a way to insert the table values in the criteria field?
thanks for the help!!

 

[lespaul]

lets say you have imported the excel list:
[tt]
NamesList

Names
Joe Blow
Jane Doe[/tt]

and in your database you have a table that contains those names (tblEmployees) and you only want to select the names in the list:

SELECT * FROM TblEmployees where NAME in (SELECT Name FROM NamesList)

or you could do something like:

SELECT * FROM TblEmployees E Inner Join NamesList L on E.Name = L.Names

HTH

Leslie