Avatar of upobDaPlaya

asked on 

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...
Microsoft OfficeVBAMicrosoft Excel

Avatar of undefined
Last Comment
Ryan Chong

8/22/2022 - Mon