I have an Access database c:\test\val.mdb
In this database I have a table "values". Values has the
fields "label1" and "date1". date1 is unique.

Now from Excel VBA I want to read label1 from this table
with date1 as key.

Can someone tell me how this is done?

Please be specific (an example would be best) - also
indicate which references I need to include in VBA to use
Access functionality

Ron