I'm getting data in one text-file for each year from an external source.
The structure in the files are the same for each file.
I want to use these files as one source in Excel.
One way I tried to use is to merge the textfiles into one and "connect" to the data with a query in Excel. The problem is to handle new data. I want to be able to, instead of merging the files, merge the data into one source in the Excel data model but how do I accomplish this?