Access - find records from list

[Mitch_s_s]

Hi,

I'm guessing this is really easy, but i'm completely new to access/sql.
I have a list of Case ID, from a specific area.
and i want to run a query to pull back info on the cases in the list.
at the moment i am inserting into cells in excel:
=A1&" or "
=B1&A2&" or "
and dragging these formulas down then copying the values in to my access query
the above method is limited as the query will only allow me to insert a certain number of characters, so it's a complete nightmare shortening the formula down every 40 or so cells
especially when i have over 2000 cases
i'm guessing there is an easier way
ie just pasting the case ids using the "IN" operator in SQL
so i'm hoping one of you guys could help me, and show me a tut or a solution to my problem

many thanks

Mitch