Excel files in Folder

[johnpjustus]

Hi,

I have a shared newtwork folder where are few excel files.

I am trying to connect to the folder using data flow inorder to fetch all the files.

To achive that, I am using Folder connection but I am only getting the list of excel files as output and not the excel files.

But If I provide the path of each excel file then I can retrieve individual excel files hpwever in this case I have to create individual connectioins for each excel files.

Does anyone know how to pull all the excel files from the folder in one shot?

Thanks,

John

[GilbertQ]

Hi @johnpjustus 

What happens when you view all the files in the folder, could you post a screenshot as quite often it does allow you to see the binary format of the files?