| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Lookup in Access return result to Excel
I am trying to do something like a vlookup in an Excel maco using ADO/VBA,
which looks up a value in an Access table and returns the corresponding value to a variable in Excel. I have tried the this: loc = "Select AE from table2 where ECT = Range("A" & rws).value" where AE and ECT are columns in table2 and rws is a counter-like variable. Any suggestions (websites, references) would be greatly appreciated!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple Lookup return 1 result | Excel Discussion (Misc queries) | |||
| Lookup value then return result from other column, varying row num | Excel Worksheet Functions | |||
| lookup for a value in multiple columns and return a result | Excel Discussion (Misc queries) | |||
| lookup value and return result in column to left | Excel Worksheet Functions | |||
| I need a Lookup to return more than 1 result | Excel Worksheet Functions | |||
Threaded Mode
