ODBC Driver for Microsoft Excel

Build 24.0.8963

ConnectionType

Specifies the file storage service, server, or file access protocol through which your Microsoft Excel files are stored and retreived.

Possible Values

Local, Amazon S3, Azure Blob Storage, Azure Data Lake Storage Gen1, Azure Data Lake Storage Gen2, Azure Data Lake Storage Gen2 SSL, Azure Files, Box, Dropbox, FTP, FTPS, Google Cloud Storage, Google Drive, HDFS, HDFS Secure, HTTP, HTTPS, IBM Object Storage Source, OneDrive, OneLake, Oracle Cloud Storage, SFTP, SharePoint REST, SharePoint SOAP, Custom Stream

Data Type

string

Default Value

"Local"

Remarks

Set the ConnectionType to one of the following:

  • Local: Microsoft Excel files stored on your local machine.
  • Amazon S3
  • Azure Blob Storage
  • Azure Data Lake Storage Gen1
  • Azure Data Lake Storage Gen2
  • Azure Data Lake Storage Gen2 SSL
  • Azure Files
  • Box
  • Dropbox
  • FTP
  • FTPS
  • Google Cloud Storage
  • Google Drive
  • HDFS
  • HDFS Secure
  • HTTP: Connects to Microsoft Excel files hosted on HTTP streams.
  • HTTPS: Connects to Microsoft Excel files hosted on HTTPS streams.
  • IBM Object Storage Source
  • OneDrive
  • OneLake
  • Oracle Cloud Storage
  • SFTP
  • SharePoint REST
  • SharePoint SOAP
  • Custom Stream

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.8963