Placing and XL file is the APpplication server and reading from there

[Former Member]

Hi All,

I have requirement like this,

i have an XL file,

I need to put that in application server and

i need to read the same file from the application server and

i need to process VA01 T-code...

Actually y i m asking this process is bcz i will have XL file in my desktop.. i need to put this process in the back ground..

Can any one give simple sample program how to do this process..

Thanks a lot...

thanks,

Suresh

[Former Member]

Hi Suresh,

You can't put the excel file on application server. You need to put the text file there.

What you can do is use ALSM_EXCEL_TO_INTERNAL_TABLE to read file from presentation server and then use OPEN DATASET... to put the file as text file on application server.

Regards,

Atish

[Former Member]

Hi

use the <b>CG3Y or CG3Z</b> transaction to place the file into Application server from Local and vice versa..

Use the OPEN dataset concept to read the fiel from Application server.

OPEN DATASET...

READ...

TRANSFER.

CLOSE dataset..

Reward points for useful Answers

Regards

Anji