Data on excel from access database based on criteria in excel?

Question

I have a MS Access database to which an excel file is connected to view output. MS Query is used to interface and fetch data based on two conditions date & ID. I am unable to specifiy the parameters in connection properties as Parameters option is disabled. My requirement is to pass values for the parameters Date & ID from excel and view the output of the query on the same sheet.

Answer 1

Hello Lyndsay, It might be easier to just link to the Excel file and create the parameter query in Access.

HTH

Jeff