I am in a job where I receive multiple Excel sheets daily that are on a standardized format. I have a master file in which I paste every new sheet and the file keeps getting bigger and bigger. Moreover, to retrieve information and prepare different tailor made statements, I have to use Pivot Tables and a lot of work has to be done manually, as there are no queries in Excel.
Please guide whether Access is feasible for performing the above mentioned task of maintaining a database of these sheets that are received daily? If yes, how can I do it the easier way which should be easier to learn for my team members too? Please remember that I don’t have to do manual data entry but import standardized Excel sheets containing multiple records, on daily basis. I am new to Access and have played around with it a little bit.
Thanks and regards.