CData ADO.NET Provider for Excel connection strings

Pseudo column names (A,B,C) are used instead.

To retrieve data from the cache, add "#Cache" to the table name. For example, to query cached data from the "Sheet" table, execute "SELECT * FROM [Sheet#Cache]".

The table metadata will also be cached instead of retrieving it from the data source. This improves connection performance. Read more here →

SELECT statements will always retrieve data from the cache. DELETE/UPDATE/INSERT statements is not allowed and will throw an exception.

Above is just an example to show how it works. It can be used both with "Auto Cache" and with "Cached Data Only / Offline Mode". Read more about using RSSBus Cache Provider in this article >>>

Pseudo column names (A,B,C) are used instead.

To retrieve data from the cache, add "#Cache" to the table name. For example, to query cached data from the "Sheet" table, execute "SELECT * FROM [Sheet#Cache]".

The table metadata will also be cached instead of retrieving it from the data source. This improves connection performance. Read more here →

SELECT statements will always retrieve data from the cache. DELETE/UPDATE/INSERT statements is not allowed and will throw an exception.

Above is just an example to show how it works. It can be used both with "Auto Cache" and with "Cached Data Only / Offline Mode". Read more about using RSSBus Cache Provider in this article >>>

Pseudo column names (A,B,C) are used instead.

To retrieve data from the cache, add "#Cache" to the table name. For example, to query cached data from the "Sheet" table, execute "SELECT * FROM [Sheet#Cache]".

The table metadata will also be cached instead of retrieving it from the data source. This improves connection performance. Read more here →

SELECT statements will always retrieve data from the cache. DELETE/UPDATE/INSERT statements is not allowed and will throw an exception.

Above is just an example to show how it works. It can be used both with "Auto Cache" and with "Cached Data Only / Offline Mode". Read more about using RSSBus Cache Provider in this article >>>

Pseudo column names (A,B,C) are used instead.

To retrieve data from the cache, add "#Cache" to the table name. For example, to query cached data from the "Sheet" table, execute "SELECT * FROM [Sheet#Cache]".

The table metadata will also be cached instead of retrieving it from the data source. This improves connection performance. Read more here →

SELECT statements will always retrieve data from the cache. DELETE/UPDATE/INSERT statements is not allowed and will throw an exception.

Above is just an example to show how it works. It can be used both with "Auto Cache" and with "Cached Data Only / Offline Mode". Read more about using RSSBus Cache Provider in this article >>>

Pseudo column names (A,B,C) are used instead.

To retrieve data from the cache, add "#Cache" to the table name. For example, to query cached data from the "Sheet" table, execute "SELECT * FROM [Sheet#Cache]".

The table metadata will also be cached instead of retrieving it from the data source. This improves connection performance. Read more here →

SELECT statements will always retrieve data from the cache. DELETE/UPDATE/INSERT statements is not allowed and will throw an exception.

Above is just an example to show how it works. It can be used both with "Auto Cache" and with "Cached Data Only / Offline Mode". Read more about using RSSBus Cache Provider in this article >>>

Pseudo column names (A,B,C) are used instead.

To retrieve data from the cache, add "#Cache" to the table name. For example, to query cached data from the "Sheet" table, execute "SELECT * FROM [Sheet#Cache]".

The table metadata will also be cached instead of retrieving it from the data source. This improves connection performance. Read more here →

SELECT statements will always retrieve data from the cache. DELETE/UPDATE/INSERT statements is not allowed and will throw an exception.

Above is just an example to show how it works. It can be used both with "Auto Cache" and with "Cached Data Only / Offline Mode". Read more about using RSSBus Cache Provider in this article >>>

Pseudo column names (A,B,C) are used instead.

To retrieve data from the cache, add "#Cache" to the table name. For example, to query cached data from the "Sheet" table, execute "SELECT * FROM [Sheet#Cache]".

The table metadata will also be cached instead of retrieving it from the data source. This improves connection performance. Read more here →

SELECT statements will always retrieve data from the cache. DELETE/UPDATE/INSERT statements is not allowed and will throw an exception.

Above is just an example to show how it works. It can be used both with "Auto Cache" and with "Cached Data Only / Offline Mode". Read more about using RSSBus Cache Provider in this article >>>