| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to get lookup data from Access Table
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup data in a variable table & retrieve data from a pivot table | Excel Worksheet Functions | |||
| How to get access 2003 data table particular data in excel. | Excel Programming | |||
| Write data to Access table with INSERT when table has auto number | Excel Programming | |||
| Importing data from Access to Excel, but I need to vary the table from Access | Excel Programming | |||
| Lookup Access data in Excel | Excel Worksheet Functions | |||
Threaded Mode
