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
-------------------------------------------------------------

Reply via email to