>Hi Naomi, Bonnie. many thanks for replying.
>
>I was really wondering of there was an Append from alternative in c#/SQLSERVER 'without' having to list each field.
>The example I gave was a simplified version of tables that could have 40/50 fields
>
>Regards,
>Gerard
>
>
No, there is no other alternative, but you can simply generate an insert select script in SSMS
If it's not broken, fix it until it is.
My Blog