First of all, it is a really big misunderstanding that Excel is a database. It is not! It is a spreadsheet.
Examples of databases are Access, MySQL, MSSQL, PostgreSQL, Oracle, DB2, JavaDB (Derby) and Hypersonic.
In fact, misusing Excel as a database is just receipt for trouble. Handle it as a spreadsheet. There are Java API´s out for this, such as Apache POI HSSF and Andy Khan JExcelAPI. Information, tutorials and examples are available at their sites.
If you actually want a database, you shouldn´t be using Excel at all. Use a real database.
Joined: Sep 02, 2008
Thank for the information .. If I would have been given the choice my work would be more easy.
The requirement is that only .. please tell me if anything can be done
Joined: Oct 08, 2006
Load the complete sheet into Java memory and use Java instead to do the work. It´s only very inefficient and memory consuming.
trunc and to_date are Oracle specific SQL functions. This is indeed not going to work in Excel (let alone another databases). I also highly doubt if the lousy ODBC bridge driver understands a little bit more than the standard SQL92 statements/functions.