> The problem is, it shouldn't even be *getting* to the second step - > building the bad data query.
Yes, it should - if you consider there is difference between an "empty" and "unmodified" row. I suspect POI picks up rows that were modified, rather than rows that contain values. Can you imagine if it didn't? POI would have to examine the values in every single cell, every time. With say 65000 rows per sheet, that would take a while. I don't know this for certain, but that would be my guess. So either modify the CFC you're using to exclude rows with all "empty" cells or change your CF code to skip them. Janet ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284307 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
