How do I in Excel VBA update Excel rows using SQL within VBA

If I have 2 sheets let say students and classes and I want to update the students tab with the class id found in the class tab would I be better off creating a SQL update rather than looping thru the class tab multiple times.  If the answer is yes can somebody give me an example of the  SQL using I assume an ADO connection...