I have the code for connection but I was looking something similar as above where the master data will be in access but the other accounts table will be in excel so the user will query access database master table for fetching the all possible matched email ids in the last column. Is that possible? Can you throw some lights on it.
I am thinking of creating a button in excel which will ask user to select the range of accounts in excel and once that is selected it will go to access database master table and fetch all possible email ids in the last column in excel.
Greetings everyone! I figured I am always asking for advice on here so now I am giving some. I found this code somewhere, Bacon Bits I believe. I had build an Access database that is tied live to some other software we have. I needed an easy way to extract data and to be able to analyze it...
be sure your table is indexed on the fields that are required for your searching. For instance, if you were searching based on Where FieldX = 'abc' then FieldX would be a candidate for indexing. Depending on the size of your dataset (it sounds large) then it might be time to consider a more robust DB solution.