ODBC guide

List Excel files

Gets all Excel files from a specific drive.

SELECT * FROM list_excel_files
WITH (
  -- Drive (SharePoint Document Library)
  DriveId='b!GtLN726LE0eY5F2BBNi14wMKmwdpCDFMn1d71ra11GuQ4DORpHy-XXXXXXXXXXXX'
  )
--You can get DriveId by selecting from 'Drives' table.