Upload files of excel to access

[tuxo99]

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.

 

[Comfy]

This is an Access Question.

You might want to Import the files into Access using linked tables.

That way any amendments to the files will be automatically reflected in Access.