Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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?