How would I use excel to generate a large update sql statement

Question

I know there's a way to have insert statements within excel. Is there one for update? so far I've managed to come up with my update statement in SQL, but I have 6000 rows to update:

= "Update table Set name = " & A1 & " Where namefk = " & E2 & ""

Basically, I want the name and namefk to be populated with fields in my excel..but I can't seem to get it right. Any help will be appreciated.

Answer 1

=CONCATENATE("update Site set SiteName='",D13,"' where Place='",A13,"' and Code='",B13,"'") =CONCATENATE("update Site set SiteName='",D13,"' where Place='",A13,"' and Code='",B13,"') =CONCATENATE("

As previously said, we can dynamically alter queries, and if we do so for one row, we simply need to drag down, and the column values will be immediately populated.

Answer 2

=CONCATENATE("update Site set SiteName='",D13,"' where Place='",A13,"' and Code='",B13,"'") =CONCATENATE("update Site set SiteName='",D13,"' where Place='",A13,"' and Code='",B13,"') =CONCATENATE

As previously said, we can dynamically alter queries, and if we do so for one row, we simply need to drag down, and the column values will be immediately populated.