If you want to find where a field value equals a list of 100+ items, typing in each criterion would be very time-consuming.
For example, you might want to query your database where zip code is one of 100 different zip codes.
You can paste from your list into the query criteria. Select the operator is in list for classic queries or contains one of the following in new queries. You can paste from Excel.
After you click Add, you see the values listed within parentheses.