First, you need to move the Truncate query outside the loop. Otherwise it is being called on each loop iteration, and erasing any records you inserted on the previous iteration.
Second, close your table with a </table> tag after the </tr> Third, you have a comment about blank rows being invalid, but you have no tests to trap for this. I'd suggest adding something like this before the insert transaction: <cfif Len(Trim(objSheet.Column1))> Then add a </cfif> after the transaction to close the <cfif> tag. HTH, Carl ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:342699 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
