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

Use VBA Code, you can query Access database via SQL statement.

--
Best regards,
---
Yongjun CHEN
=================================
XLDataSoft - Data Analysis Expert, Excel/VBA Specialist
- - - - www.XLDataSoft.com - - - -
Free Excel-Based Data Processing Tool is Available for Download
Free Excel / VBA Training Materials is Available for Download
=================================
"1scant" wrote in
message ...

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

OK. Please, help me out with the VBA code to:
Open ARMS.mdb (and do we have to explicitly share it if others will
will be accessing this mdb at the same time?)
Function (sql) to find names referenced in Excel A2:A10 if they exist
in ARMS.mdb field DSN. If found, return value of field NU. If not
found, return "ERR".
Close ARMS.mdb


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