How can I import multiple .xlsx and .xls files into multiple tables in Access? I have 100 .xslx and .xls files with different formats and I need to import them all separately into Access keeping their original file names intact.

Folder example: 
C:\Users\username\Desktop\2019_data\foldername\

sample names  of the many different sheets in the folder=

LGPO221154-1-ANDERSON-CELL 18-49.xlsx
LGPO221154-1-ANDERSON-CELL 50_UP.xlsx
LGPO222975_1_CELL_49_UNDER_Bandera.XLS
LGPO222975_1_LL_49_UNDER_Comal.XLS
I haven't done MSSQL in a while but if I remember you can do a ssis package.  I think its part of sql management studio. Where you can read in files and do inserts.