View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jerm jerm is offline
external usenet poster
 
Posts: 5
Default 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