title: How would I use excel to generate a large update sql statement?
body: <p>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:</p>
  
  <blockquote>
    <p>= "Update table    Set name = " &amp; A1 &amp; "    Where namefk = " &amp; E2 &amp; ""</p>
  </blockquote>
  
  <p>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.</p>