| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlookup and Access Database Table
Can vlookup be used to get a result from an Access Database Table?
Thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
vlookup and Access Database Table
The vlookup function itself is an Excel function and as such can only
retrieve data from an excel sheet. However you may be able to use the import external data menu option in the Data menu to retrieve your data from the access database, pull it into your excel workbook and then use the vlookup function. I never tried this myself, but maybe the idea can be applied. -- Jeroen van Nieuwkerk "finster26" wrote: Can vlookup be used to get a result from an Access Database Table? Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| vlookup and microsoft access | Excel Worksheet Functions | |||
| Access Excel Linked Text and Number Issues | Excel Discussion (Misc queries) | |||
| How do I access data stored in a SQL server for vlookup function? | Excel Worksheet Functions | |||
| excel to get data from an access database | Excel Discussion (Misc queries) | |||
| vlookup function in excel referencing an access table | Excel Worksheet Functions | |||
Linear Mode
