Using clob/blob data types

Hello,

I'm trying to find the best way to load data into my table with more than 4000 characters. I'm assuming that using the following data type was the way to go. With that, I'm not sure how to go about loading these files into my table.

I have a speadsheet that have a 10 fields and two fields are more than 4000 characters.

Any help would be greatly appreciated.

Thanks

If the fields are text based and more than 4000 chars then better go for a CLOB.

Srini