I have a connection in my excel sheet to an access database which specifies the data to retrieve based on an SQL query.

I'd like to modify the SQL so that the WHERE clause is limited to a range on an excel sheet.

I'm not sure whether this is possible, or the syntax, but something like this:
Please Login or Register  to view this content.
So, something along these lines - SELECT PN, DE, SC, MN FROM database PT WHERE PT=every value in Sheet1$A11:A20

Is this possible to do this?

Thanks