Ok here is the deal. I have an excel file. I can query through it no problem. I have to take results and update a SQL database. Again no problem. Except some of the field names in the excel file have spaces. We receive this file from another party so we can't remove the spaces from the file.
Can we 1. rename the field names in excel and remove the spaces that way? or 2. Somehow convert it during the query so it will work. Example: <CFQUERY> UPDATE TABLE SET CASENUM = '#CASE NUMBER#' WHERE WHATEVER = WHATEVER </CFQUERY> It errors out at NUMBER because of the space. Any suggestions? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
