Forum Discussion
Databases in MS Access (Sharepoint Folder)
When it comes to the window as your second image shows, click Transform Data rather than Combine. It will open Power Query editor and you will see all folders and files there. Drag the scroll bar right to find Folder Path column. Then click on the down-arrow icon to filter it to keep only the path of the specific sub-folder you want to import data from. After that, combine files in Content column. The next steps are similar to those when connecting to a local folder.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
When it comes to the window as your second image shows, click Transform Data rather than Combine. It will open Power Query editor and you will see all folders and files there. Drag the scroll bar right to find Folder Path column. Then click on the down-arrow icon to filter it to keep only the path of the specific sub-folder you want to import data from. After that, combine files in Content column. The next steps are similar to those when connecting to a local folder.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Thank you very much, that's definitely the way, I just tried and it worked perfectly.