title: How do I convert Excel data into a SQL insert?
body: <p>I need to upload several thousand addresses to a web portal. I do not have access to the site itself and must do so with the following INSERT statement: </p>
  
  <pre><code>INSERT INTO Address (AddressTypeID, Address1,City, State, Zip, Phone, PersonName, DisplayName, IsDefault, StatusID, UserID) 
  VALUES ('1', 'SQL Herro st', 'SLC', '42', '84087', '8015957258', 'Bruce Wayne', 'Bruces address', 'False', '1', '3019')
  </code></pre>
  
  <p>I have the addresses in Excel but I don't really have any idea how to iterate this code a thousand times while importing the data.</p>