Hi,
i have the following which works
but is there an easier way if the worksheet data matches the table? ie same no of columns
as with 20+ columns to update it gets tedious typing it all out.
Sub updateSQL()
Application.ScreenUpdating = False
var1 = Sheet3.Range("A2")
Set cnn =...