Using .dbf file in Model Builder

[JohnMcConalogue]

I have imported an Excel file using the "Excel To Table" tool. The file has been converted to a .dbf file.

I want to select the contents of the .dbf file and process these records within Model builder. 

Anyone know how to do this?

[DanPatterson_Retired · Accepted solution]

Select by Attributes will allow you to select certain records meeting a condition.

Or you can use the whole table as is.

What do you want to do with the table?  It sounds like you want to use the table as an input to some task.  What is the next step?

[JohnMcConalogue]

I have a field in the table called "Towns". There are a number of records in the table and each record in the table has a value in their "Towns" field.  I also have a separate shapefile which contains "town names". I want to be able to select all the records in the Table that has a "Town" value which is also present in the shapefile.

[DanPatterson_Retired]

join the two tables (attribute join), then you can query the combined result