Brent,

The code below will look at each row in Excel column A, Make a call to
Access to find the lookup value in the table 2 and return the lookup value
into column B in Excel.

I was under the impression that you were passing an Excel value to Access to
return some value that you would store in Excel. That is what this code does.

Try it then let me know if it works for your solution.

--
Stewart Rogers
DataSort Software, L.C.