Excel files in Folder

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