How do I write to specific cells in Excel? ... C#, OleDb

The query that is not working is used for update not insert, but you can use for insert here try:

string sql = "Update [" + stSheetName + "$A2:B2] SET A2 = '5', B2 = 'e'";

---

Fouad Roumieh