How can I import multiple .xlsx and .xls files into multiple tables in Access?
0
votes
1
answer
104
views
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
Asked by Juan Zendejas
(1 rep)
Feb 17, 2020, 11:58 PM
Last activity: Feb 18, 2020, 12:09 PM
Last activity: Feb 18, 2020, 12:09 PM