Thanks Gents, Bonehead play on my part - pointing to the wrong server - fixed the path and worked exactly as described. Great addition to the options to offer for allowing users to upload data to the server for processing.
Thanks again, Rob On Apr 29, 12:42 pm, FrognutUnl <[email protected]> wrote: > 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/1954SoI 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- Hide quoted text - > > - Show quoted text - --~--~---------~--~----~------------~-------~--~----~ 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 !! -~----------~----~----~----~------~----~------~--~---
