The attached shows how to import a mass set of xls files within a folder into an MSAccess file.

On the import form in the example, you just click the browse button and select the folder, then click the import button and it will import all the xls files in that folder.

After Importing, all the import excel file names are saved into a 'tracking' type MSAccess table with the date/time the excel file was imported (the tracking table is called: 1_ImportedFilesListing)

Note: The vba coding to do this is not complex or lengthy - see the module called: Importing Module for the importing code itself (modify the importing code as needed for xlsx files)