I agree using something like Navicat to load the data would be a much better solution, but if you must use code, then I would parse those table names and replace all of the bad characters and spaces before creating the tables.
Special characters and spaces just cause too many problems to even try to use in table names. The only non-alphanumeric character I EVER use in a table name is an underscore. Is there some reason you can't rename the tables when they're created to strip away the offensive characters? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:338488 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm