topic Re: Combine multiple excel files into one in Developer

Combine multiple excel files into one

Anonymous — Wed, 10 Jan 2018 14:46:20 GMT

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

Re: Combine multiple excel files into one

tjd — Wed, 10 Jan 2018 14:51:18 GMT

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.

Re: Combine multiple excel files into one

v-chuncz-msft — Thu, 11 Jan 2018 09:31:21 GMT

@Anonymous,

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