Chad,

Yep. I understand that you found an acceptable way to do it, but for future reference, I'm almost 100% sure that the only thing that you were missing was to make the tablenames the same.

~~Bonnie



>Bonnie,
>
>I didn't know about the name needing to be the same. I have tried the simple call like you posted at one point. That's what I tried first. I know at one point, I was able to have the values from the second table overwrite the values in the first table. I just haven't been able to get the second table be appended to the first (column-wise, not row-wise). I will keep playing with it, but for now, I have it working another way. At this point, it's more of a curiousity thing for me.
>
>Thanks,
>Chad
>
>>Well, right off the bat, only two things jump out at me:
>>
>>1) Your table names are not the same. I think they need to be.
>>
>>2) The actual Merge call. You've said that you've tried various combinations of parameters for it, but the simplest one should work. And that is simply:
>>

>>            ds.Merge(dt);
>>

>>Did you try that one?
>>
>>
>>~~Bonnie