How to lookup values in Access db?

  • Thread starter Thread starter 1scant
  • Start date Start date
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
 
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
=================================
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

making a portion of reference to a worksheet variable in a formula 1
Lookup in named range 3
Pivot & External DB & Lookup 1
Q on how to search for text in a column 10
How to match the values within Tables? 1
How to reference a null value? ie: =Lookup("", B2:B4, A2:A4) 6
Excel Worksheet to Access DB 2
Cell reference value to remain constant in a sort using Paste Link 2

Back
Top