Chuck Finley wrote:
> I am reading the information and setting it into variables vA1....vA32 and > then I read the next row into vB1....vB32. With 32 columns to compare the > If.. .vA1 = .vB1 and .vA2 = .vB2......VA32 = VB32 then..... runs pretty > slow. I was hopping for a better way! This file can be 10 K records per > month. Thank to those who have and will responded to my question. It should run pretty fast if you then do the deletions as a group, then step to the next row that exists. The delete duplications that others have suggested will not work if you have a unique autonum column. If you eliminate the autonum column, the del dupl should work. bill
