JDBC-ODBC Bridge Driver Enables Spreadsheet-as-database Interaction

Average Rating: 4.2/5 | Rate this item | 30 users have rated this item.

JDBC-ODBC Bridge Driver Enables Spreadsheet-as-database Interaction (cont'd)

Spreadsheets as Databases
In this article, you learned how to interact with Excel spreadsheets as if they were database tables. You facilitated this ability by first registering a spreadsheet as an ODBC Data Source. You could then use the JDBC-ODBC bridge driver to interact with your spreadsheet using SQL.

With your newly learned technique, you can use the inherent power of SQL to read from and write to your spreadsheets. Leveraging SQL's built-in functions adds to any Java programmer's arsenal. However, you should not consider using Microsoft Excel for the database functionality of your enterprise. Use a much more scalable database solution (e.g., IBM DB2 UDB, Oracle Database, Microsoft SQL Server, etc) for housing your enterprise data.

Previous Page: Interact with Your Spreadsheet (with Java)

Download The Code for this Article

Kulvir Singh Bhogal works as an IBM consultant, devising and implementing Java-centric solutions at customer sites across the nation. .

Page 1: Introduction	Page 3: Spreadsheets as Databases
Page 2: Interact with Your Spreadsheet (with Java)