ODBC guide

Query from a custom cell range

Reads a custom cell range from a tab (for example My sheet) in a spreadsheet. Supply the range (for example A4:GR) and the spreadsheet ID.

SELECT * FROM [My sheet]
WITH(
  Range='A4:GR',
  ArrayTransEnableCustomColumns='False',
  SpreadSheetId='1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms'
)