| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Lookup from Excel to Access
Combobox1 = DLookup("[V05 GOVT]", "End of year incentive", "[AS400 #] = " _ & [Cell T28]) Is there a way to have ComboBox1 on Excel spreadsheet and it do a lookup in access database Cell T28 = Field in Volume.mdb [AS400 #] Lookup Database Volume.mdb Table [End of year incentive] Field [V05 CONV) and the result would be in combobox1 -- ca1358 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup information in Access Database | Excel Discussion (Misc queries) | |||
| How to lookup values in Access db? | Excel Discussion (Misc queries) | |||
| excel lookup, like access | Excel Discussion (Misc queries) | |||
| Code to 'lookup' value in Access database | Excel Discussion (Misc queries) | |||
| Lookup Access data in Excel | Excel Worksheet Functions | |||
Hybrid Mode
