11-07-2007 3:36 PM
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.
11-07-2007 3:40 PM
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,
KC