Please provide a solution for this problem

Former Member — Wed, 07 Nov 2007 15:36:24 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.

so i can upload until 32 charecters but i need all the 54 charecters.

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

Regards,

Chaithanya.

Re: Please provide a solution for this problem

Former Member — Wed, 07 Nov 2007 15:40:15 GMT

Hi,

You can do it in 2 steps,

1. Use Gui_Upload to upload the excel sheet into an Internal table

2. Loop at ITAB.

Insert ZTAB from ITAB.

Endloop.

Try this,