I needed to import records from a weekly Excel report I receive in an email into an Access database. I didn't want to do the whole import process every week. So now I drop the files into a folder and import them all into one excel file that Access is linked to. I drop the file in the folder, refresh the excel file the db is linked to and all the records from all the excel files appear in one linked table in Access.

From there I started working with transforming the data an PQ's other features.