Daily Excel Data

[ch_riadh]

Hi,

I have an app, i'm loading daily data from excel sheet, the user add a new excel sheet every day,
For example : in day 3 i want to be able to see the data related to the three days in my app.

How i can load all the excels ?

Thanks

[adamdavi3s]

this might help

Loading from multiple Excel files and multiple sheets

There are so many threads on this subject that I am sure if you search you will find the answer 😉

[Anonymous · Accepted solution]

You can load all at once using wildcard "*" if they are in the exact same format the will auto concatenate into one table:

Assume your files are called

mydata_20161121.xlsx

mydata_20161122.xlsx

mydata_20161123.xlsx

YourTable:

Load *

From mydata_*.xlsx

...;

Use the wildcard to substitute the variable part of the filename.

[#4]

This is working...!