Hi All,

I am using UPDATE query from Excel to Access.


I have 1000 rows with unique IDS ( same IDS in Access Database Table)


I need to UPDATE for 1000 IDS status. Right now I am using like this.


I want to know is there any better option to do this ??


For R = 4 To 1000


ID = Trim(Cells(R, "A").Value)
STS = Trim(Cells(R, "F").Value)


SQL = "UPDATE TRACKER SET TRACKER.STATUS = '" & STS & "'"
SQL = SQL & " WHERE ID = '" & ID & "'"


rs.Open SQL, db, adOpenDynamic, adLockOptimistic, adCmdText


Next R