Thank you Lowell for your fast reply,

but the thing is i need to insert the data from 140 folders,here your are inmporting the data from 4 folders,so for 140 folderss i need to do the same thing,

is there any other procedure like keeping the whole thing in the loop .