I have several years of Excel data in separate year files. (Example: 2014 sales, 2015 sales etc...). As I continue to add 2017 data as part of the overall load statement, the time it takes the load to run is increasing.
I'd like to update the 2017 Excel file and only spend the time reloading that data instead of all the other files as that data has not changed. How do you write the load statement to keep the old sales years data and only load or run the 2017 file?