G
Guest
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
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