I have excel which has 6000 records per day i have splited this data in to 6 excel files using divisor and added these 6 files in queue,now all file path are in queue,but iam not sure every day i get 6000 records it can be less or more in that case how load the data in load single transaction.Please some one help me on this.
Yes i can but to process 6000 records its take average of 6 to 7 hrs. To use multi bot splitted the records in different excel so that i can reduce the process time