upload excel file from Application server

[Former Member]

Hi,

I have an excel file on application sever saved without an extension. (Saved Excel file without extension, as we cannot save file on unix serve with extensions (customised)). I have to read this file in my program using Open Dataset command.

code which is already there is

internal table is type string.

open file for input in text mode.

if sy-subrc = 0.

do.

read file into internal table.

enddo.

close dataset.

when i receive the data in internal table it changes to some special characters. Please advise.

[Former Member]

Hi ,

Instead of open file for input in text mode use the open file for input in BINARY mode. Binary mode will not allow any special characters.

Regards,

Vishvesh.

if helpful, rewards it.