‎2006 Jul 18 7:47 AM
Is there any way to upload excel file from application server to database tables? Also, is there any way to rename an excel file in the application server to xls file?
‎2006 Jul 18 7:52 AM
‎2006 Jul 18 8:00 AM
Hi Sandeep,
GUI_UPLOAD does tht.
Reward Points if helpful.
Regards,
Harini
‎2006 Jul 18 8:16 AM
Hi,
Uploading excel files from application server use <b>OPEN DATASET <filename> FOR INPUT IN TEXT MODE.</b>
DO .
READ DATASET <filename> INTO <ur structure>.
IF SY-SUBRC NE 0.
EXIT.
ENDIF.
APPEND <ur structure> TO <itab>.
ENDDO.
<b>Reward if helpful</b>
Regards,
Shakuntala
‎2006 Jul 18 8:25 AM