Toad Load Character as NULL

I have a spreadsheet that when I load into Toad, one character from one cell does not load. When you look at the character it looks ok. I have tried copying that same character from another column where it worked ok, but it still does not load. You are not given any error so the only way to catch is visually, but with a big table that is a problem. Does anyone have any ideas to solve this? Thanks

You indicated "one character from one cell does not load. When you look at the character it looks ok. I have tried copying that same character from another column where it worked ok, but it still does not load" do the cells you are working with contain just the one character seemingly identical character or do they contain additional data? If they contain something other than the character, maybe the character sequence is impacting the behavior. What character is causing the problem?

Copyright 1998-2015 Ziff Davis, LLC (Toolbox.com). All rights reserved. All product names are trademarks of their respective companies. Toolbox.com is not
affiliated with or endorsed by any company listed at this site.