>Thanks (all),
>but yes, 90% of the fields are matching. I dont want to have to delete the extra fields.
>I need to merge 6 "orders" tables from 6 working systems each with subtle differences.
>
>Naomi had some code.. but not sure I want to have to use it.
>
>still a bit perplexed.
I think that in this case it would be best to write some loop and check each field whether it exists already in the destination cursor. If not, add it.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)