Spot on there. That is exactly what I want.

I am using SQL 2000. On the limit, hard to say, but shouldn't go more than 30 times.

There is no timestamp, unfortunately. Just the fact that the column name is New and Old defines the latest value. For your example, im afraid that is not a possible...

Hmm...

Ok, here is a sample recordset:

20060403144140010000120504265320500006006001

20060403144141010000120504265320500006006001

20060406145613010000120504265320500006006001

The actual record set is 690 characters in length so i will spare that much.

Yeah, the cursor approach i have thought of, but as u...

Thanks for that guys.

It was infact that i had declared the activex script after the text connection was established.

I changed it so that i do the activex stuff first, and...

Thanks guys,

I am infact using Adam's approach regarding putting the data into a temporary table and extracting it from that later on.

RE the getting the file from the directory, still...

I managed to get the source columns all unique. Still get the error.

Got no clue what else could be the matter..!!!!

Any clue as to what else could cause this ?

Wow, thats an awesome script. But is there a way of storing the "Error Description" as well?? Like...Table not added because of key constraint, or Divide by Zero exception. Is...