> can i caopy paste excle sheet ( 36 rows X 4 Columns ) into > textarea and then use appendlist to reorder them and insert > them into data base?
You wouldn't use listAppend() in that situation. There are a number of approaches here, but essentially what you'll want to do is look over the input line by line and break out the individual columns within that line and insert them into your database. -Justin ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:5520 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
