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?
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
| User | Count |
|---|---|
| 6 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |