| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup information in Access Database
Hi,
I've got an Access Database that is 128k rows. I dont want to pull it in to XL as the file is too big, and is more than one Tab. I would like to interrogate this table using Array formulae, Vlookup and wanted to know how (if at all possible) i would write the location of the source data, eg =vlookup(A1,'Data1.mdb!Table',offset) Thanks John |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| client information database | Excel Discussion (Misc queries) | |||
| Code to 'lookup' value in Access database | Excel Discussion (Misc queries) | |||
| how do I set up a database for client information | Excel Discussion (Misc queries) | |||
| Database Information | Excel Worksheet Functions | |||
| Excel as a database and sorting information | Excel Discussion (Misc queries) | |||
Threaded Mode
