I'm posting this here, because i'm not sure where else and i have a gut feeling i will be doing this with VB.
My goal is the following:
I have an Access database (with four fields, of which the first one is the key) which I'd like to use in Excel.
The table contains about 1,5 million records, and the idea is the user in Excel should enter a number (which should represent the first field in the table), and by the click of a button, excel should pick up the three other fields of the record.
Now, I have searched a lot, and am not sure what's the best way to approach such a challenge.
I'd much appreciate any advice on the matter, as this project is of quite an importance to me.
Thanks very much in advance