>Thanks, but it is not that simple. >I have plenty of things to check, convert, validate, etc. >Don't forget an Excel file is created and filled by humans ;-)
I would figure out a way to use my RDBMS to handle this. Navicat or SQL Server tools to do it. Then clean the data or whatever once it's in there. To reference those crappy fieldnames you'll need to use aliases SELECT some[space]crap[space] fieldname as somethingICanUse FROM someTable ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338486 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm