I think the last argument (-1) is the number of ROWS (top to bottom) to return. The SELECT * in the SQL instructs the driver to return all COLUMNS in each row. But you probably already knew all that. Just for posterity...
Looks like your SQL is confusing the driver just when you reference your "table". Unfortunately, what's missing - from both Paul and FrogNutUnl's contribution to this thread - is the exact SQL they use to reference the contents of their Excel files. I Google the same stuff that you probably did, like: http://www.devx.com/Java/Article/17848/1954 So I can understand the syntax now. Have you tried some different files? Could it be that "address" is a reserved word? Renaming the tab? Does your Excel file even have column names? OK, now I'm just grasping... Alan K. Holden --~--~---------~--~----~------------~-------~--~----~ Open BlueDragon Public Mailing List http://groups.google.com/group/openbd?hl=en official site @ http://www.openbluedragon.org/ !! save a network - trim replies before posting !! -~----------~----~----~----~------~----~------~--~---
