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: Access Excel Files within Sub-Folders Using CData Excel Drivers