Hey,
This is going to be a hard one to upload, so I'll try my best to explain. I have a couple files in a folder, set up the exact same way (I copied one and changed the file name). I then have another file that I want to give me both of the tables in each of these files combined. So in 2016, I click Data, New Query, From File, From Folder, I browse for the folder that contains my 2 files and click ok, from the tutorials I have followed online I should then have the option to combine, however this is missing, I only have Load.
Any help appreciated. I've attached the MASTER document I want to contain all my data and then 1 of my Template docs where the data will be input.
Thanks,
Bookmarks