Ever needed to get a list of files in a folder? I have. I've actually created VBA code to do this. Well, Data Explorer lets me create a dynamic list of files with just a few clicks.
I select the From Folder option and enter my target folder's path.
.
This immediately activates the query window with a view into all the files in my selected folder.
.
I can see a drill icon that lets me expand the Attributes column to show additional information. In this case, I want to include the Kind and Size fields.
.
After confirming my changes, I get a refreshable table which lists the files I have in my folder.
I'm not sure this is exactly what the 'From Folder' option in Data Explorer was intended to do, but I find this feature extremely handy.
.
.
