The error means that it is unable to find the file. Outside of that, everything appears to be working okay. I was able to run your code without any problems.
Wes On Apr 28, 3:56 pm, Alan Holden <[email protected]> wrote: > 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/1954So 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 !! -~----------~----~----~----~------~----~------~--~---
