Trying to get data from excel in my java project faced one problem (on java7)
seems the latest HXTT excel driver is working (in squirrel it shows the content of the table)
but when trying to run simple sql statement receiving errors like
--select * from Groups;
Error: Failed to find table Groups in database groups (excel table and sheet has identical name)
may be you can give me some advice what may be wrong?
What's your jdbc url? Whether do you have a groups.xls(x) file?
You should use sheet name as table name. For instance, select * from sheet1.