# Access Excel Data from Subfolders of a Root Resource Directory

**URL:** <https://community.cdata.com/t/access-excel-data-from-subfolders-of-a-root-resource-directory/1018>\
**Category:** CData Drivers\
**Tags:** excel-connector, discussion, driver, excel, cdata-drivers, file\
**Created:** [February 5, 2025, 7:25am UTC](https://community.cdata.com/t/access-excel-data-from-subfolders-of-a-root-resource-directory/1018 "2025-02-05T07:25:48Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Mohsin](https://avatars.discourse-cdn.com/v4/letter/m/41988e/32.png) [@Mohsin](https://community.cdata.com/u/Mohsin)\
**Post date:** [February 5, 2025, 7:25am UTC](https://community.cdata.com/t/access-excel-data-from-subfolders-of-a-root-resource-directory/1018/1 "2025-02-05T07:25:48Z")

</div>

Recently, a new subfolder file access feature was released for the CData **Microsoft Excel drivers** , enabling seamless retrieval of Excel files stored in subdirectories of a root resource folder. Key parameters include:

- **IncludeSubdirectories** – Enables scanning of subfolders within the root folder to locate Excel files.
- **DirectoryRetrievalDepth** – Defines how deep the scan goes within subdirectories. Use `-1` to scan all subfolders within the root directory.
- **PathSeparator** – Prepends the relative folder path to schema names using a customizable delimiter (default: “\_”), ensuring unique table identification.

Check out the complete guide on how to set it up locally and access Excel sheets as tables:&nbsp;[Access Excel Files within Sub-Folders Using CData Excel Drivers](https://www.cdata.com/kb/articles/excel-sub-directories.rst)