Insert Into statement using arrays in Delphi isn't working
<p>So I am doing a Delphi 7 project for school that requires me to integrate SQL with a Delphi program. I am using Microsoft access as my database. I am trying to use arrays of string in a insert into statement, but for some reason i constantly get    Syntax error in INSERT INTO statement. My insert code is :</p>

<pre><code>ADOQuery1.SQL.Clear;                     
ADOQuery1.SQL.Add('INSERT INTO ' + IntToStr(o) + ' (' + column[t] + ')');
ADOQuery1.SQL.Add('VALUES ("' + Stats[t] + '")');  
ADOQuery1.SQL.Add('WHERE No = "' + Stats[1] + '" ');                            
ADOQuery1.ExecSQL;
</code></pre>

<p><code>o</code> is a number that should indicate the table name, <code>column[t]</code> is the column that i want <code>Stats[t]</code> to appear in. </p>

<p>How can I fix this error?</p>