power query - EXCEL 2016 / merge files form folder

Hey folks,

I want to merge these 3 files into one database via Data / import Data.

Important: these files are all in one folder. So if I import a new file, I want to update the master file and want that the new imported file to be displayed

Only "Tabelle 1" is part of the masterfile.


I only want the files to be merged with this excel function. But it gives an error message. I need to know how the excel file has to be constructed to be merged from an folder. I don't want a vba-merge-solution. The given excel merge solution is what I want to use.

thanks for your help!

Skills: Data Processing, Excel, Programming

See more: visualisierung von cad daten, merge multiple excel files horizontally, sqlexpress import von daten, tradestation daten von metatrader, script merge different excel files excel file, insert daten von formular sql tabelle, web service query excel, web query excel, refresh web query excel vba, php script delete folder files, flash contact form source files, form submit button microsoft word excel, txt files merge vbnet, form sending files, clone von bwin, word excel power, text files merge, vba textdatei von unix, shirt von tool, importare file edt

About the Employer:
( 24 reviews ) Riegelsberg, Germany

Project ID: #11209716

1 freelancer is bidding on average $55 for this job

$150 USD in 3 days
(212 Reviews)

A proposal has not yet been provided

$55 USD in 1 day
(9 Reviews)
$45 USD in 3 days
(0 Reviews)