compare two dataset without using loop

May 14 2009 1:23 PM

i have file which has 4000 record and i have table it also has more than 6000 record so i have to create two data set and compare ti for adding only new record from file into same table so how do i do please help me