Querying and Updating SQL Database Using Excel
 

Hi,

I want to query a table in an SQL db, then I would like to edit the
table and update the database with the edited results.
Is this possible? Or is it suggested?
I am thinking of just adding a button that says 'Update DB' but then I
guess I would have to check each row in the excel sheet against the
database... unless there is an easier method of doing so.

regards,
jerm