Importing Access Data into Excel w/ Multiple Criteria

[mudbug]

Greetings,

Here is my question? I have a master database in Access too large to pull into Excel. I need to import data for one column of a table into access based on three different criteria. For instance, I need to pull Access data into C2 (and all of column C), where a2 and b2 match the respective cells in a record in Access.

Please any help will do. If this could be done with a lookup or index-match function that would be great. Otherwise a macro is fine. All help is very much appreciated.

Thanks,

WildMaxD

 

[Norie]

Why don't you create an appropriate query in Access?

Then goto Data>Get External Data... and import the query.