Right now ? I'd use Alteryx to union the data.
If you can wait .... you can possibly do it in version 10 (you will have to wait until it's released though)
1 of 1 people found this helpful
If your data have the same schema (identical column fields) import the first Excel file and create a Extract (TDE).
Just click on the datasource (right bottom) and select the follow option: Extract > Append Data From File > Choose the file which you need to use, look:
I hope it works.