Tips on Introspecting Multiple Files in a Network Share Folder
If the root path does not show the network mapped drives, the Root Path can be specified as UNC path without using the Browse button.
1. Define a new or edit an existing Microsoft Excel (non-ODBC) data source.
2. On the Basic tab for the Local File System value, if the Browse button does not allow you to navigate to the machine or root directory that contains your Excel data you can type the root directory location in the Root Path field. For example:
R:/<mymachinename>/work/users/mega/excel-ds
Note: The direction of the slashes in the root path are important. If you know your files are in a particular directory and they do not show in the introspection window, modify the direction of the slashes in your root pathname and save the data source.
3. Save the Microsoft Excel (non-ODBC) data source.
4. For an existing data source, on the Basic tab, scroll to and click the Add/Remove Resources button.
5. Multiple files in the network share folder should now be available for introspection.