Getting excel file data by using FTP connections

Former Member — Mon, 30 Jun 2008 06:19:20 GMT

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.

So please help me if any one knows solution.

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

Re: Getting excel file data by using FTP connections

Former Member — Mon, 30 Jun 2008 06:25:02 GMT

hi,

you are accessing file using FTP.

try this....

If user is providing a file then tell him to put that file on application server and from application server you can easily access the file...