Hey, When you say "field name" in your email, are you referring to the column? Or is it some calculated, "not really a column" value in the spreadsheet?
And secondly, what are you using to create the JDBC connection. I ask not out of concern that it is the flaw in your process, but out of morbid geek curiousity. I've found several different options for doing that and I was wondering which you had decided was the better choice. Howard On Fri, Apr 18, 2008 at 2:25 PM, Scott Councill < [EMAIL PROTECTED]> wrote: > Thanks to all for comments. I should have been more detailed. Yes, > spaces in field names is very bad. I am working with a process that uploads > an Excel Spreadsheet that is created by a client. Yes, I could go back to > them and tell them "no spaces", but I wanted to try to find a solution that > wouldn't require that. Once the SS has been uploaded, I then create a JDBC > connection to the workbook and read the data in a specific sheet. That > works fine. Now I have a query object that I am trying to join to a SQL > database query to compare values. Yes, I can loop over the SS query and do > lots of separate queries but I wanted to create a single query solution with > a JOIN statement. > -- Howard Fore, [EMAIL PROTECTED] "The universe tends toward maximum irony. Don't push it." - Jeff Atwood ------------------------------------------------------------- Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -------------------------------------------------------------