Look-up Value from CCESS DB and bring import all Rows

[rangequestion]

Hi,

I have an Access DB with over 200k rows. I want to import rows based on a field in Excel (a unique ID called "CIF") which would match the ID field ("CIF") in Access

I want to import all related rows along with the field names for that ID and not just the first. Any ideas?

thanks!