Is it possible to use an excel table as parameters for access queries? Currently I have 4 access files to perform the same process, but with different filters (I used 4 files to leave organized). The filters are basically DATE START, END DATE and a DESCRIPTION field. I would like to leave this information in excel and leave the access just to process.
If this solution is not possible, can you load multiple parameters at a time in access queries? It would have the same practical effect as it would load the parameters of each process before execution.