I have been using a Match function to see if a reference ($A2) has a
match in another Excell worksheet. However, the latter worksheet has
over 190K references which I have divided into four columns so that I
don't exceed 65K rows. Very inefficient and complex. I have created
this reference table in Access (190K records) and would like for my
Excell sheet to look up (or test for a match) the reference in the
Access db.

Seems like this should be very straight forward and apriori for
learning how to interface different applications. Exactly how do I do
this?


--
1scant
------------------------------------------------------------------------
1scant's Profile: http://www.excelforum.com/member.php...o&userid=31635
View this thread: http://www.excelforum.com/showthread...hreadid=547176