Excel Power Query - Only New Files Using 'From Folder'

Dear All


I have a situation where each week 100 csv files are being uploaded automatically to a specific folder. Each csv file is very small, containing 7 rows x 12 columns of data.

I need to bring these files in to Excel so that the data contained in the csv files may be checked and any amendments made to the Excel data only.

I was going to use the 'From Folder' functionality as part of Power Query to import the data in the csv files in to one table in Excel.

Is it possible to utilise the 'From Folder' functionality to only import the data in files that have been added since the previous Refresh and append this new data to the existing table? The reason for this is to preserve any amended made to the previous weeks data in the Excel table. I appreciate this is not the normal functionality of the 'From Folder' feature.


If anyone can think of a solution or direct my to an article discussing only importing new files using 'From Folder' I would be very grateful



SH

Hi Bernie

Unfortunately amending the source csv files is not an option as these must be retained unchanged.

Thanks Bernie, I didn't think of that.