uploading excel from application server

[Former Member]

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?

[Former Member]

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?

[naimesh_patel]

Hello,

You need to use OPEN DATASET to read the data.

and for renaming:

1. read data into your program

2. put data back into new file

3. delete old file with DELETE DATASET.

regards,

Naimesh

[Former Member]

You can use ALSM_EXCEL_TO_INT_TABLE function to upload a excel to internal tablt from your app server. Then you can save it to the database table.

Regards,

Ravi

Note : Please mark all the helpful answers

[Former Member]

Rename the file like this.

Slight midifications required.

CONCATENATE w_saptempdir

'/'

it_matfile

INTO w_saptempdir.

CONCATENATE w_sapfldir

'/'

it_matfile

INTO w_sapfldir.

TRANSLATE: w_saptempdir TO LOWER CASE,

w_sapfldir TO LOWER CASE.

CONCATENATE 'mv' w_saptempdir w_sapfldir INTO var-parcom SEPARATED BY

space.

CALL 'SYSTEM'

ID 'COMMAND' FIELD var-parcom

ID 'TAB' FIELD tabl-sys.