How to lookup values in Access db?

1

1scant

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

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

Daniel CHEN

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
=================================
 
1

1scant

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
 
Top