Forum Discussion
Combine multiple excel files into one
Hello, I want to combine multiple excel files into one database. Every day I get 1 new excel file in the same format but different data and put it into the same folder. I used the tutorial on y...
In the Query Editor, Home tab, use the Reduce Rows menu, Remove Rows button to select "Remove Top N Rows". Set it for 25 and it should remove those rows automatically for you when it does the data import.
