Forum Discussion
Solved
Using Query and Connections
Is it possible to pull data from multiple Excel files in a folder using one Query and populate one worksheet with data from each of the Excel files. Thanks.
Hello,
don't give up so fast. Click Data ribbon > Get Data > From File > From Folder, then navigate to the desired folder.
Have you tried the Get Data from folder (Get & Transform Data tab). Using this you can combine all workbooks in that folder into one data table.