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