View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Nigel[_3_] Nigel[_3_] is offline
external usenet poster
 
Posts: 31
Default How to get lookup data from Access Table

I have found that setting up a prequery in the access database then pass the
value to filter the table in Access then pass the value back to Excel. What
code have you so far?

--

Regards,
Nigel




"Madiya" wrote in message
...
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