Community
Application Development and Automation 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
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Upload excel data from unix path

Karan_Chopra_
Active Participant

‎2010 Sep 23 7:54 AM

0 Likes
434

I have to upload data from UNIX path with contains 4 files in zip format which has Excel files in them .

How can I upload that data into a ztable, how can I seperate the fields in excel for diffent fields in ztable to be uploaded

What is the FM for uploading the same , please tell me the steps as I am doing it for the first time

Moderator message: data upload questions = FAQ, please search before posting.

locked by: Thomas Zloch on Sep 23, 2010 5:39 PM

1 REPLY 1
Read only

mrio_espinheira
Participant

‎2010 Sep 23 12:05 PM

0 Likes
330

Hello,

I think there isn't a FM to upload a Excel file from the Application Server, but you can upload a CSV file using OPEN/READ DATASET. I had the same problem, and that was the only way to solve it.

If you can upload the Excel files from the Front-End, then use FM ALSM_EXCEL_TO_INTERNAL_TABLE.

Best regards,

Mário Espinheira