Object reference not set to an instance

[polinenileela_b]

Hi Everyone, Need a help regarding my object reference error - I have read a column from the excel and put in my collection - now I have to loop through my collection and get each field (db. tables)and put in to my query and run in my toad - In my collection I have current values with the column heading - when in put in my query its not running (collection. Field ) this convention I have used in my query - but I have not created field manually,.. so when I run my BP not able to read the heading name from my current values instead looking for field name - So its throwing an error of object reference not set to an instance.. Please help is much appreciated Thanks Leela

[John__Carter]

Sounds like the Excel headings contain characters that are not compatible with a BP collection. If the only illegal character is a dot, then there is a function in the collection utility called something like 'Remove dots from Headings'. Otherwise suggest you 'clean' the Excel header row before reading into a collection (by replacing the illegal characters with something else) and close the Excel file without saving changes.