I have a process that loops through a local folder and imports excel files into a SQL database.
During the loop the excel file are moved from a INPUT folder to a ARCHIVE folder.
Can someone help me move the excel file from the INPUT folder to a REJECTED folder if there is an error. AND continue the Loop through other files.
Any help and direction would be appreciated.