Hello,
I need to upload 4 files of excel to access.
The files have the same structure.
The 4 files have multiple worksheets, however i only want to upload the last one (name Total).
The files and the access database are in a folder in destock.
I want to know how to code it so i don´t have to enter in each excel file and copy it to the access database.
Thank you.
I need to upload 4 files of excel to access.
The files have the same structure.
The 4 files have multiple worksheets, however i only want to upload the last one (name Total).
The files and the access database are in a folder in destock.
I want to know how to code it so i don´t have to enter in each excel file and copy it to the access database.
Thank you.