ODBC guide

Insert multiple rows into a sheet from a CSV file

Bulk inserts multiple rows into a sheet using CSV data as the source. Reads rows from a CSV file using an ODBC connection and writes them into the specified range in the sheet.

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