Database update

[michaelw]

hi another prob here, i have a datset imported from excel, that i wish to update the data to a database table. the dataset hase two coloums [URN], [invoiceNo] i wish to update a table called jobs where the URN matches and updates it with the invoice number placed in the excel dataset, any help would be great, i know i should use the update metho of the data adapter but the SQL statement and how i pass it is not so celar.

Regards