Can you clarify if the data is lying in MS Access? if yes, there is an option to export the data from MS Access to MS Excel using macro.
MS Excel help
I am trying to figure out if I can run this type of report using Excel?
For example, I have a worksheet with a list of names, but I want to pull or find out all the names on that list who has a birthday in June. Am I able to run a report some how to show all the people in that list who’s DOB is in a specific month?
Easiest way to do this is to add a formula i.e. =month(dob), copy the formula down the entire list and then use the Filter functionality.