Updating a SQL table with information entered in an Excel Database
 

I have an Excel workbook that I would like to present some information i.e.
Sales Rep Name, ID, Customer, Invoice ID, Invoice Amount, Status (Paid or
Open), Commissions Paid Y/N, Commission Amount, DatePaid, etc. In short I
want Excel to allow me to show data based on a select query have the fields
filled in for some people and then feed that new information back to the SQL
table with an update query. I know - it sounds like a large project - can
anyone suggest some white papers, etc. that will help me get started.

I am proficient in VBA, Visual Basic and SQL procedures, etc and I have full
permissions on the database I will be using, I have no problem displaying
data for certain parametersi in an Excel sheet - but I want to update that
information in Excel and update the SQL table (single) that contains those
fields.

thanks