bit late now, my finger's are sore and i'm ready for home 🙂

Was hoping there was some form of shorthand way of doing it. There are 236 fields!

Never mind though, many thanks for your help!!!

quote:

---

Something like this (Check it out in BOL):

update <master_Table>

set col1 = <temporary_table>.col1, col2 = <temporary_table>.col2 ....

from <master_table>, <temporary_table>

...

quote:

---

insert <master_table>

select <col1>, <col2>

from <temporary_table>

where not exists (select * from <master_table> where <temporary_table>.<Primary_Key> = <master_table>.<primary_key> )

ie insert a row where it does...

quote:

---

only importing 'new' data?

What about creating a DTS package?

You can use the DTS Import/Export wizard and in one of the last steps...