Getting excel file data from different server.

[Former Member]

HI all,

I have done one interface program.In that i am getting one text file data by using FTP connections successfully.

FTP_CONNECT

FTP_COMMAND

FTP_CLIENT_TO_R3

FTP_R3_TO_CLIENT

Now my requirement has been changed to get excel file data instead of text file data from the non sap server.

I have tried in same way as getting text file data.but it is going to dump and some times getting some #$## like this in my internal table.

So pls guide me what is the procedure to get excel file data from other server by using FTP connections only.

Regards,

Lokesh

[Former Member]

hi,

refer to the libnk below:

http://voiceofabap.blogspot.com/2008/05/uploading-data-directly-from-excel-file.html

to upload excel u can use the FM

'ALSM_EXCEL_TO_INTERNAL_TABLE'

with luck,

pritam.