Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Get data from Access tbl using Vlookup formula
Is it possible to refer to an Access tbl in a Vlookup formula or is
their a solution that achieves the same result? The access tbl is too large to bring into a 2003 Excel worksheet and I also cannot filter the tbl enough to fit into the 65 000 rows. I would like to use such a "super-sized" vlookup formula in a number of different excel workbooks, so it must be fairly simple to install. Would a user-defined VB function do the trick? (I read somewhere that it has some limitations) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup---using data outside the range specified in the formula | Excel Worksheet Functions | |||
Looking for a formula to look up data - Not vlookup | Excel Discussion (Misc queries) | |||
Using VLOOKUP when referencing data from Access | Excel Worksheet Functions | |||
VLookup to merge Access Query data into Excel Report | Excel Discussion (Misc queries) | |||
How do I access data stored in a SQL server for vlookup function? | Excel Worksheet Functions |