Excel Cell Ranges using SQL – Named – Unnamed – ODBC – JDBC

How to query Excel files using ODBC – JDBC? Summary : Why use square brackets for SQL against Excel? How to access range of cells from Excel? How to use un-named range of cells? This topic is covered in various tutorial for InfoCaptor. These following snippets are taken directly from Microsoft website as easy reference … Read more