I've got it working pretty darned good - except for one problem. If there's a NULL cell in the Excel sheet, it's throwing an error
"Element CELL is undefined in LOCAL." LOCAL.CellType = LOCAL.Cell.GetCellType(); If I go into my Excel sheet and just enter a space in the cells, no error. So, I'm trying a try/catch block to force the cell type to string (1), if it's NULL since I know that's what all the values are in the sheets being used anyway: for ( LOCAL.ColumnIndex = 0 ; LOCAL.ColumnIndex LT LOCAL.ColumnCount ; LOCAL.ColumnIndex = (LOCAL.ColumnIndex + 1) ){ LOCAL.Cell = LOCAL.Row.GetCell( JavaCast( "int", LOCAL.ColumnIndex )); // Get the type of data in this cell. try { LOCAL.CellType = LOCAL.Cell.GetCellType(); } catch(any excpt) { LOCAL.CellType = 1 } But, that doesn't seem to be working either. Anybody got a clue? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307994 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4