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.
NOW THE PROBLEM:
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!