SQL examples for ODBC

The following SQL examples demonstrate common use cases for this connector. Select a scenario below to view the query syntax and parameters required to interact with OneDrive.

• Copy a file or folder
• Create or update a CSV file from external source
• Create or update a JSON file from external source
• Delete a file or folder
• Download a file
• Download a file by path
• Download file and convert to PDF or HTML
• Move a file or folder
• Read a drive
• Read all files (recursive)
• Read all files and folders (recursive)
• Read all folders (recursive)
• Read compressed CSV file (Zip/Gzip, streaming)
• Read compressed JSON file (Zip/Gzip, streaming)
• Read CSV file (streaming, no download)
• Read drives
• Read Excel data as formatted text or formula
• Read Excel file worksheets
• Read Excel files
• Read Excel worksheet data (auto-detect range)
• Read Excel worksheet data for a cell range
• Read files and folders shared with me
• Read files from group or other user's drive
• Read files in a folder
• Read files in a folder path (recursive)
• Read folders in a folder
• Read items in a folder (non-recursive)
• Read JSON file (streaming, no download)
• Read root
• Rename a file or folder
• Upload a file
• Upload a file (overwrite if exists)
• Upload a file with original timestamp