Lookup all possible matches in access

[Ebraham]

Hi

I have one master table and other as accounts table. In master table i have around 7-8 columns out of which two columns are account number and email_ids. and in accounts table i have several columns out of which one column is account number.

i want to create a query which Vlook-up all possible matches of email ids on the bases of account number in one cell field from master table.

To better understand this is how i do in excel link . i am looking for a similar solution in access.

 

[welshgasman]

Yes, you can query an Access DB from Excel.

Google that phrase or add with VBA

 

[Jalal Kasmani]

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.

 

[welshgasman]

No, as I have only accessessed Excel from Access, not the other way around. Even then the Excel wokbook was linked so just looked like a table to Access. Sorry.

 

[alansidman]

See if this link helps you.

Excel VBA runs Access Parameter Query

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...

chandoo.org

 

[Ebraham]

with larger datasets of 1M rows , access hangs with the above approach for lookup all matches within access, any idea ?

 

[xenou]

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.