Excel File=C:\myExcelFile.xlsx;Cache Location=C:\cache.db;Auto Cache=true;Offline=false;
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]".
This connection string (Caching data using CData ADO.NET Provider for Excel) can be used for connections to
Excel 2000, Excel 2002, Excel 2003, Excel 2007, Excel 2010, Excel 2013 and Excel 97.
Start over in the connection string reference index.
You can also get help in the Q&A forums where you can ask your own question.
The kb articles contains how-tos and instructions and you can search for anything if you're not sure were to look.