The scenario is like this, I want to extract data from excel file and load into mssql. However, there are several files of excel and I put those files inside "Folder_In" folder. Also, there may be another excel files will be added into "Folder_Input" and need to be extracted.
There are two folder with name "Folder_In" and "Folder_Out". "Folder_In" is used to stored the excel files which the data of each files will be extracted and once a file has competed extracted, that file will be moved-out and will be stored in "Folder_Out".
I just wonder, i have 2 files with same format inside a folder which refer to year 2006 and 2009 and i wants to extract these files automatically by using tFileList. I was successfully extracted the data each year with respective values but the year was replicate to 2006 even though the values are for year 2009.