load file excel

[MauriceLudo]

Hello,
I would like to know the best solution to load excel files every month at once, each file contains the same fields, just the values ​​that change each month.
Thank you for your help.
Best regards

Maurice

[Gysbert_Wassenaar]

You can load all the excel files using a * as wildcard:

MyData:

LOAD * FROM [D:\ExcelFiles\*.xlsx] (ooxml, embedded label, table is Sheet1);

Or you can use a loop: loop through to load all files from a folder and its subfolders?