<p>Do you have any tricks for generating SQL statements, mainly INSERTs, in Excel for various data import scenarios?</p>

<p>I'm really getting tired of writing formulas with like </p>

<p><code>="INSERT INTO Table (ID, Name) VALUES (" &amp; C2 &amp; ", '" &amp; D2 &amp; "')"</code></p>

The semi-colon needs to be inside the last double quote with a closing paren.  When adding single quotes around a string, remember to add them outside your selected cell.
(spaces added for visibility - remove before inserting)
```
=CONCATENATE("insert into table (id, name) values (",C2,",' ",D2," ');")
```
Here is another view:
```
=CONCATENATE("insert into table (id, date, price) values (",C3,",'",D3,"',",B3,");")
```