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