I have an Access database where I export a table to Excel in order to be able to use the rank function. I then re-import the updated files.

However, for the rankings to be updated, I have to open and save then close each Excel file (there are numerous files that I have to do this with) and was wondering if anyone knows of a way to automate this process?

I am also hoping there is an easier way to do this from within Access, so any advice would be gratefully appreciated!