ODBC guide

Update multiple rows in a sheet from a CSV file

Bulk updates multiple rows in a sheet using CSV data as the source. Reads rows from a CSV file via an ODBC connection (for example ZappySys CSV Driver) and writes them into the target sheet and range.

UPDATE [My sheet]
SOURCE(
  'ODBC',
  'Driver={ZappySys CSV Driver};',
  'SELECT * FROM $ WITH (SRC=''c:\data\orders.csv'')'
)
WITH(
  WriteRange='G9',
  SpreadSheetId='1az2H8ZYk7BvjddVTqPR-LfDjX9IRpIpjCDpFPe9EzkU'
)