long text upload problem from excel

hello,

i have an excel file with a column for long text in it.

im using TEXT_CONVERT_XLS_TO_SAP fm to upload to itab

but the long text field is filling only upto 255 characters.

searched a lot in sdn reagrding this and common solutins are:

use ALSM_EXCEL_TO_INTERNAL_TABLE fm

copy ALSM_EXCEL_TO_INTERNAL_TABLE and table strcuture in it and increase length of it

and use gui_upload.

i tried all these things but none worked out for me.

pls help

Ujwal