ADO.NET Provider for Excel

Build 20.0.7655

URI

The Uniform Resource Identifier (URI) for the Excel resource location.

Data Type

string

Default Value

""

Remarks

Set the URI property to specify a path to a file or stream.

A comma-separated list of URIs is supported to include multiple files. See for more advanced features available for parsing and merging multiple files.

Below are examples of the URI formats for the available data sources:

Service providerURI formats
Local localPath

file://localPath

HTTP or HTTPS http://remoteStream

https://remoteStream

Amazon S3 s3://remotePath
Google Drive gdrive://remotePath
Box box://remotePath
FTP or FTPS ftp://server:port/remotePath

ftps://server:port/remotepath

SFTP sftp://server:port/remotePath
Sharepoint sp://https://server/remotePath

Example Connection Strings and Queries

Below are example connection strings to Excel files or streams.

Service providerURI formats Connection exampleQuery example (if folder1 contains file1.Excel or streamname1 is a Excel stream)
Local localPath

file://localPath

URI=C:\folder1 SELECT * FROM file1
HTTP or HTTPS http://remoteStream

https://remoteStream

URI=http://www.host1.com/streamname1; SELECT * FROM streamedtable
Amazon S3 s3://bucket1/folder1 URI=s3://bucket1/folder1; AWSAccessKey=token1; AWSSecretKey=secret1; AWSRegion=OHIO; SELECT * FROM file1
Google Drive gdrive://remotePath URI=gdrive://folder1;InitiateOAuth=GETANDREFRESH; SELECT * FROM file1
Box box://remotePath URI=box://folder1; InitiateOAuth=GETANDREFRESH; OAuthClientId=oauthclientid1; OAuthClientSecret=oauthcliensecret1; CallbackUrl=http://localhost:12345;SELECT * FROM file1
FTP or FTPS ftp://server:port/remotePath

ftps://server:port/remotepath

URI=ftps://localhost:990/folder1; User=user1; Password=password1; SELECT * FROM file1
SFTP sftp://server:port/remotePath URI=sftp://127.0.0.1:22/remotePath; User=user1; Password=password1; SELECT * FROM file1
Sharepoint sp://https://server/remotePath URI=sp://https://domain.sharepoint.com/Documents; User=user1; Password=password1; SELECT * FROM file1

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7655