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 youtube: https://www.youtube.com/watch?v=a7E29H5ZUmE
It's understandable and works with test data but not for my excel files
In this tutorial the first row is the header and that's my problem.
The first 25 rows (red) from each excel file must be deleted.
Row 26 (orange) is the header and after row 26 the data.
I can change this by hand each time but it must be automated (way of working now!).
How can this problem be fixed en delete those 25 first rows from each excel file and combine it into one database.
Kind regards,
Mark
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.
2 Replies
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.