Please provide a solution for this problem

Former Member — Wed, 07 Nov 2007 15:34:22 GMT

Hi,

I need to upload a excelfile into database table.

i am using the function module KCD_EXCEL_OLE_TO_INT_CONVERT.

this fm reads cell by cell in excel and the internal in which we are going to upload trhe data from the excel is of type kcde_cells.

This table kcde_cells has three fields

1.row

2.col

3.value

row and col stores row and column no and value stores the value in a particular row and column.

this field value is type char with length 32.

but my value of length 54.

How can i upload the entire value that is of legnth 54.

Regards,

Chaithanya.

Re: Please provide a solution for this problem

naimesh_patel — Wed, 07 Nov 2007 15:38:16 GMT

it seems this will not be possible with this FM to upload values more than 32 character.

May be try some other FMs like GUI_UPLOAD, if possible.

Regards,

Naimesh Patel