Combine multiple excel files into one

[Anonymous]

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

[tjd · Accepted solution]

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.

[v-chuncz-msft · Accepted solution]

@Anonymous,

For more complex task, do research into The Advanced Editor.

[tjd · Accepted solution]

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.