Thread
:
How to get lookup data from Access Table
View Single Post
#
2
Posted to microsoft.public.excel.programming
Nigel[_3_]
external usenet poster
Posts: 31
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
Reply With Quote
Nigel[_3_]
View Public Profile
Find all posts by Nigel[_3_]