Filtering Database from a Column in Excel (1 Viewer)

[Bill Bisco]

Dear all,

I would like to be able to have a linked excel file in my Access Database, and then filter a query based on the values from that linked excel file. I can of course manually add to the query criteria, but I'm hoping that there's a more elegant solution. I have searched around but I couldn't find what I was looking for.

Any help is appreciated,

Bill

 

[Bill Bisco]

I found the answer, I use the create query wizard and create an exclusion query!!! SUPER AWESOME!