View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
KD[_6_] KD[_6_] is offline
external usenet poster
 
Posts: 2
Default 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)