Passing the contents of a cell to access and returning a result?

[KirbyWan]

Howdy all,

So the FAA provides an access database of all PMA parts that can be downloaded here:

https://rgl.faa.gov/Regulatory_and_Guidance_Library/rgpma.nsf/MainFrame?OpenFrameSet

I have an excel sheet with a column of components to check to see if they are in the database (the ReplacedPartNumber column on the Parts table.) and how many instances there are.
How do I pass the text contents of a cell and then return the number of instances?

My first attempt was just to copy the column of parts to check into a table (CER Parts) in access and do a join between that table and the Parts table. which failed because the ReplacedPartNumber field is memo which can't have perform a join but I found a work around for that using the info from this website: How to join on memo fields in Microsoft Access which worked. So now I have a query in access that will give me a table of every record in Parts that has a match in the table CER Parts.

But I don't know how to pass the parts in my excel table to access and get the result back.

This is a one time check so I don't need to keep refreshing this data, but I do this check on a different column of parts regularly so I'd like to just select the range of data and click a button to get the result.

Thanks all,

-Kirby