title: update table from excel file MySql
body: <pre><code>update initl
  set initl.High=Exc.High
  from INITLIMITS as initl
  INNER JOIN  OPENROWSET('Microsoft.Jet.OLEDB.4.0',
  'Excel 8.0;Database=C:\Users\nkavroulakis\Downloads\nikos\excel boundaries\server04testbound.xls;',
  'SELECT Validator, SensorParam, High, Low FROM [Sheet1$]')as Exc
  ON initl.Validator=Exc.Validator and initl.Sensor=Exc.Sensor and initl.Parameter=Exc.Parameter
  where initl.Validator='NV200' and initl.Sensor='Stacker Full' and initl.Parameter='Gain1'
  </code></pre>
  
  <p>I am trying to update a database table from an excel file but i am getting an error on <code>OPENROWSET--&gt; erron in sql syntax.</code>
  Any ideas how to solve this????</p>