Connection for Excel file

[Former Member]

Hi everyone,

I am new to ABAP and i have some questions to ask.

Here is the situation.

My client want SAP data to update automatically from excel file from another computer daily.

1. I know somehow we can get data from excel to internal table and to sap table.

2. I can use SM36 to do the background process, so i can run the update daily.

Here is my real question:

1.  i use FM ALSM_EXCEL_TO_INTERNAL_TABLE to get the data, but the ROW and Column are difficult to adjust. Is there any other ways i can get the        data to internal table and to SAP table?

2. How can i connect sap to another computer to take the excel file? is it possible?

[Former Member]

Hi everyone,

I am new to ABAP and i have some questions to ask.

Here is the situation.

My client want SAP data to update automatically from excel file from another computer daily.

1. I know somehow we can get data from excel to internal table and to sap table.

2. I can use SM36 to do the background process, so i can run the update daily.

Here is my real question:

1.  i use FM ALSM_EXCEL_TO_INTERNAL_TABLE to get the data, but the ROW and Column are difficult to adjust. Is there any other ways i can get the        data to internal table and to SAP table?

2. How can i connect sap to another computer to take the excel file? is it possible?

[former_member129652]

Hi,

Put the file on a FTP server.  Run a report in background to retrieve files from FTP server.  However, you'd better use csv file instead of excel file.  The reason is that ALSM_EXCEL_TO_INTERNAL_TABLE only works in foreground.

[Former Member]

Thanks.

However, my client has no FTP server. The file is on the end user computer.

One more problem is that i am having trouble with ALSM_EXCEL_TO_INTERNAL_TABLE.

i can get the data to internal table which is "DATA IT TYPE TABLE OF ALSMEX_TABLINE", but how can i transfer data from IT to my ZTABLE since the IT have only 3 fields which are ROW, COL, and VALUE?

How can i transfer data from internal table using ALSM_EXCEL_TO_INTERNAL_TABLE to my ZTABLE?

[former_member216914]

Hi,

Find BDC tutorial..

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/309cb157-738d-2910-7691-b74c4ddba...

[Former Member]

Thanks.

However, my client has no FTP server. The file is on the end user computer.

One more problem is that i am having trouble with ALSM_EXCEL_TO_INTERNAL_TABLE.

i can get the data to internal table which is "DATA IT TYPE TABLE OF ALSMEX_TABLINE", but how can i transfer data from IT to my ZTABLE since the IT have only 3 fields which are ROW, COL, and VALUE?

How can i transfer data from internal table using ALSM_EXCEL_TO_INTERNAL_TABLEto my ZTABLE?