Skip to Content
avatar image
Former Member

How to loop thru multiple folders where each folder has multiple excel files

Hi DS Gurus. I have three folders ( Folder1…Folder3) and for each folder I have multiple excel files(similar file format) which need to be loaded to HANA. I need to loop thru all the three folders and load all the excel files to HANA. Each folder has a set of excel files which are of unique file formats. There is every possibility that a new folder can get added and looking for automating this as well. Please advice. Thanks!

Folder1 -> Fileformat1_1.xls

Folder1 -> Fileformat1_2.xls

Folder2 -> Fileformat2_1.xls

Folder2 -> Fileformat2_2.xls

Folder3 -> Fileformat3_1.xls

Folder3 -> Fileformat3_2.xls

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers