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

KirbyWan

New Member
Joined
Mar 24, 2021
Messages
1
Office Version
  1. 365
Platform
  1. Windows
Howdy all,

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


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
 

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

Forum statistics

Threads
1,147,517
Messages
5,741,631
Members
423,674
Latest member
Charles2dodo

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top