Change column name of a dbf file
<p>I have this items in my dbase file (.dbf)</p>

<pre><code>INDICE  NOME    COR ESTILO  ESCALA
100     SAOJOAO      18      0,00
</code></pre>

<p>I need to change column name of <code>INDICE</code> to <code>ID</code>, so I use this code:</p>

<pre><code>  while not ADOQuery1.Eof do
    begin
      Adoquery1.Edit;
      ADOQuery1.FieldByName('NOME').TEXT:= 'ID';
      Adoquery1.Post;
      ADOQuery1.Next;
    end;
</code></pre>

<p>When I run the above I get these results:</p>

<pre><code>INDICE  NOME    COR ESTILO  ESCALA
 ID     SAOJOAO      18      0,00
</code></pre>

<p>Connection string used:
<code>Driver={Microsoft dBASE Driver (*.dbf)};DriverID=277;Dbq=C:_workspace\projects\DBFEditor\te‌​mp</code></p>

<p>I have a system that need import dbf file and only recognize a file which have id column name.</p>