Import All Files (Get Data) from Sharepoint Folder

[deharris]

I'm looking for a solution that would use the Get Data function in excel to query and combine all files that reside in a Sharepoint document library. I'm able to connect to specific files but the number of files in the document library may change over time (expected to increase). Is there a way to gather and combine them all at one time regardless of how many there are?
thank you

 

[sandy666]

maybe it will help: Extracting a SharePoint List