topic Function module to upload the data from an excel file into ztable in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/function-module-to-upload-the-data-from-an-excel-file-into-ztable/m-p/4208744#M1005764 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Can anyone suggest me a function module to upload the data from an excel file into ztable other than the function module ALSM_EXCEL_TO_INTERNAL_TABLE.</P></BODY></HTML> Tue, 15 Jul 2008 07:59:42 GMT Former Member 2008-07-15T07:59:42Z Function module to upload the data from an excel file into ztable https://community.sap.com/t5/application-development-and-automation-discussions/function-module-to-upload-the-data-from-an-excel-file-into-ztable/m-p/4208744#M1005764 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Can anyone suggest me a function module to upload the data from an excel file into ztable other than the function module ALSM_EXCEL_TO_INTERNAL_TABLE.</P></BODY></HTML> Tue, 15 Jul 2008 07:59:42 GMT https://community.sap.com/t5/application-development-and-automation-discussions/function-module-to-upload-the-data-from-an-excel-file-into-ztable/m-p/4208744#M1005764 Former Member 2008-07-15T07:59:42Z Re: Function module to upload the data from an excel file into ztable https://community.sap.com/t5/application-development-and-automation-discussions/function-module-to-upload-the-data-from-an-excel-file-into-ztable/m-p/4208745#M1005765 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Use this FM:</P><P></P><PRE><CODE>TEXT_CONVERT_XLS_TO_SAP</CODE></PRE><P>********************************************************</P><P></P><P>For example, go through tje following link:</P><P><A href="http://www.sapdevelopment.co.uk/file/file_upexcel.htm" target="test_blank">http://www.sapdevelopment.co.uk/file/file_upexcel.htm</A></P><P></P><P>Thanks,</P><P>Shailaja</P><P></P><P>Edited by: Shailaja on Jul 15, 2008 10:11 AM</P></BODY></HTML> Tue, 15 Jul 2008 08:01:40 GMT https://community.sap.com/t5/application-development-and-automation-discussions/function-module-to-upload-the-data-from-an-excel-file-into-ztable/m-p/4208745#M1005765 Former Member 2008-07-15T08:01:40Z Re: Function module to upload the data from an excel file into ztable https://community.sap.com/t5/application-development-and-automation-discussions/function-module-to-upload-the-data-from-an-excel-file-into-ztable/m-p/4208746#M1005766 <HTML><HEAD></HEAD><BODY><P><A class="jive_macro jive_macro_message" href="https://community.sap.com/" __jive_macro_name="message" modifiedtitle="true" __default_attr="5407849"></A></P></BODY></HTML> Tue, 15 Jul 2008 08:03:31 GMT https://community.sap.com/t5/application-development-and-automation-discussions/function-module-to-upload-the-data-from-an-excel-file-into-ztable/m-p/4208746#M1005766 Former Member 2008-07-15T08:03:31Z Re: Function module to upload the data from an excel file into ztable https://community.sap.com/t5/application-development-and-automation-discussions/function-module-to-upload-the-data-from-an-excel-file-into-ztable/m-p/4208747#M1005767 <HTML><HEAD></HEAD><BODY><P>Welcome to SDN,</P><P></P><P>just see these report in se38 for more help.</P><PRE><CODE>FILA_HELP_UPLOAD_EXCEL_01 Report FILA_HELP_UPLOAD_EXCEL_01 FILA_HELP_UPLOAD_EXCEL_03 Report FILA_HELP_UPLOAD_EXCEL_03</CODE></PRE><P> </P><P></P><P>also you can use:</P><P></P><PRE><CODE>TYPE-POOLS: truxs . DATA: it_raw TYPE truxs_t_text_data. PARAMETER: pfile LIKE rlgrap-filename." OBLIGATORY. CALL FUNCTION 'TEXT_CONVERT_XLS_TO_SAP' EXPORTING * I_FIELD_SEPERATOR = i_line_header = 'X' i_tab_raw_data = it_raw i_filename = pfile TABLES i_tab_converted_data = it_excel[] * EXCEPTIONS * CONVERSION_FAILED = 1 * OTHERS = 2 . IF sy-subrc &lt;&gt; 0. * MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO * WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4. ENDIF.</CODE></PRE><P></P><P>Amit.</P></BODY></HTML> Tue, 15 Jul 2008 08:08:37 GMT https://community.sap.com/t5/application-development-and-automation-discussions/function-module-to-upload-the-data-from-an-excel-file-into-ztable/m-p/4208747#M1005767 Former Member 2008-07-15T08:08:37Z Re: Function module to upload the data from an excel file into ztable https://community.sap.com/t5/application-development-and-automation-discussions/function-module-to-upload-the-data-from-an-excel-file-into-ztable/m-p/4208748#M1005768 <HTML><HEAD></HEAD><BODY><P>There is no any FM that ll directly load ur data to Ztable.</P><P>Instead u can do one thing u load the data into ur Internal table</P><P>And from interal Table u can load ur ztable.</P><P></P><P>use this FM for loading into IT</P><PRE><CODE> TEXT_CONVERT_XLS_TO_SAP </CODE></PRE><P></P><P>then </P><P></P><PRE><CODE> insert &lt;ztable&gt; from IT. </CODE></PRE><P></P></BODY></HTML> Tue, 15 Jul 2008 08:12:36 GMT https://community.sap.com/t5/application-development-and-automation-discussions/function-module-to-upload-the-data-from-an-excel-file-into-ztable/m-p/4208748#M1005768 Former Member 2008-07-15T08:12:36Z