ODBC guide

Update Row Values (horizontal)

Update a row horizontally by setting values across columns. Use MajorDimension='ROWS' to perform a horizontal update starting at the specified cell.

UPDATE [Sheet1]
SET Column1='A1', Column2='A2', Column3='A3'
WITH(
  WriteRange='A5',
  MajorDimension='ROWS' --Update Horizontal
  --MajorDimension='COLUMNS' --Update Vertical
)