Hi,
I have a access database which is updated daily. It has around
20,00,000 records with 56 columns.
It is always available at the same place/path with same name (C:
\GRSN.ACCDB).

I need to lookup a value from excel and retrive all columns of that
value in Excel from access database table.
So far I have succeeded in connecting and getting all the records
using ADO.
But I want only that specific value just like vlookup in excel.
Can someone pl help me with this please?

I am using Excel 2007 and Access 2007.

Regards,
Madiya