Link Excel linked table field to IBM query field

I'm an Excel person, not Access, so I'm stumbling around in the dark!

I have a preexisting query in Access, querying an IBM database.
Every time I want info I have to enter one, two or ten search criteria into Field PONum

I want to create a list in Excel, join it to the query Field PONum and just populate the Excel file with Hundreds of PONum(s) and return everything.
Then I can use Index/Match on the results and reduce the thousands of times I have to run the Access query.

SO this is what I've done so far:

I made a list in Excel of 7 and 8 character whole numbers that can all be found in the IBM database.
Col A is Text with preceding zeros so all are 8 characters - Header PO_Txt
Col B is General, so Excel will assume numeric - Header PO_Num

Using New Datasource > from file Excel I linked this Excel file to a new table in Access.
Then I linked the PO_Num in Excel table to the field in Access query with an inner join. (Also tried PO_Txt
And changed the SQL in the SQL View on my preexisting query

I can't get the same error, so I can't provide the text, but a search led me to believe it's because the data types don't match.
So I tried to determine the data type.
Using the Database Documenter I learned the field PONum is Type: Time & Size: 16
(But the results ALWAYS return a 7 or 8 character whole number and many of them are sequential)

Now I'm getting a timeout #1013.

I believe it's working now because
1. If I put in one or two criteria in Field PONum I get results
2. If I put in criteria that doesn't exist in the Excel file I get NO results

But I want ALL results for ALL entries in the Excel table

I tried criteria Like "*" and get the timeout #1013

I never got an error prior to adding the Excel table.