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

JDBC with SQLserver – Connection refused: connect

If you are trying to use SQLserver with InfoCaptor and are using the SQL Studio Express 2005 then you might encounter connection refused error Please try the following setup before attempting to connect open the Configuration Manager Start -> Microsoft SQL Server 2005 -> Configuration Tools -> SQL Server Configuration Manager 2. Then at the … Read more

Dashboards & Competition: Who are Dashboard Vendors

There are tons of vendors providing Dashboard technology in one form or other. Most of these vendors are huge software companies and they charge a hefty license fee for their software. Do you want to spend 100K to million dollars on their software? This is just the license fee. You need to account for the … Read more