I am currently attempting to get Excel to get some information from an Access File (currently set to Read Only).
The Access databse has just 4 columns. Postcode, Postcode2, X_Coord, Y_Coord.
What I want do is to VLOOKUP from an Access database.
Is this possible?
The reason for this, is that I'm not keen on putting the 1,778,023 * 4 cells into an Excel page. It would be technically feasable (26 columns of 65535), but I suspect that Excel would crawl to a halt.
Help!