Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Performance question combine Excel data - Better to use Transform Data or Excel.Workbook([Content])

Hi all,  I need to combine data from multiple Excel files. The Excel files are all alike. I am wondering what is the best method to keep my file performant.      What is the best method to combin...
Need Help
Tips and Tricks
mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
4 years ago

If you are bringing in the same data and keep all the same columns with the same data types, the resulting file size should be the same.  Please check for differences in columns and/or data types.

 

Pat