On 12/15/06, Karl <[EMAIL PROTECTED]> wrote: > I will have data to routinely import into SQL Server from Excel files > constructed with goofy column headers like "Business Classification" > and "Owner's Name" that may contain spaces and/or single quotes.
(snipped) disclaimer up front...i didn't read all of the post :) 2 things: 1) you can use the array notation with query data. queryName[columnName][n] (where 'n' is the current row being referenced) 2) if you can alias the column names in the SQL to something more "CF Friendly", that would avoid having to go the array notation route mentioned above. -- Charlie Griefer ================================================ "...All the world shall be your enemy, Prince with a Thousand Enemies, and whenever they catch you, they will kill you. But first they must catch you, digger, listener, runner, prince with a swift warning. Be cunning and full of tricks and your people shall never be destroyed." ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264169 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
