problem with fetching data
I'm using 'HXTT Excel' type 4 drivers to access and manipulate MS Excel data. The operations are done directly on MS Excel sheet. When I tries to read a sheet having 2000 records by select query, the resultset gives just 100 rows.
I edited code as stmt.setMaxRow(200) then also it returns 100 rows. I rewritten stmt.setMaxRow(0) to impose 'no limit ' over resultset but then also result was same.
I can't understand what the mess is? Is it excel problem or the driver implementation for method setMaxRow(int) is null?
Plz help me if u know more...