Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Getting excel file data from different server.

Former Member
0 Kudos

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

1 REPLY 1

Former Member
0 Kudos

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.