title: Update ADO excel with two tables
body: <p>I'm trying to change values of an excel workbook using Update but something is wrong i.e. y want to get the value from table B and put it in table a</p>
  
  <p>my code is this, can you help me?</p>
  
  <pre><code>UPDATE [Data$] 
   SET A.[D ArtN] = B.[D ArtC]
   FROM [Datos$] as A
   INNER JOIN [Productos$] as B
   ON A.[Art] = B.[ArtC]
  </code></pre>