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
|