Consolidate numerous files with the same header into a single file

Hello,

I have at least 11000 spreadsheet files that each has 2 rows ( 1st row: for the header; 2nd row: for the data entry); I would like to consolidate all the files into one,
What is the number of maximum source file does ETL-TOOL can accommodate? Is this doable?

Ian

Ian.

Yes, it is doable, provided that your source files have same structure:
Same field names
Same Field order.
If it is the case you can use process all your files using mask.
Bear in mind that excel can only store 1 mln of records in single sheet.

Thanks Peter!

This helps a lot. I'll reach out to again if I encounter any difficulties.