Problem in uploading EXCEL file to Application Server

[Former Member]

hi, can any one solve my problem.

EXCEL file is there on the presentation server.

By using FM 'ALSM_EXCEL_TO_INTERNAL_TABLE' , i am getting that file into internal table .

After that i am transferring that from internal tanle to App. Server Using 'TRANSFER DATASET'.

but in App. Server the data is different.

before the data i am getting like this.

00010001 DATA

00010002 DATA

00010003 DATA

00010004 DATA

How Can i maintain that data as in EXCEL FILE.

[g_srivastava]

Hi Rahul,

As far as I think there might be some error in loading the file if it is not properly written.The other possibility is that the function module entry may contain error.Though it worked for me.

  OPEN DATASET p_filename FOR INPUT IN TEXT MODE ENCODING DEFAULT.
  DO.
    READ DATASET p_filedw INTO fs_*.
    IF sy-subrc <> 0.
     EXIT.

Hope it might be helpful to you.

Have a best day ahead.