topic Re: error in uploading from excel sheet in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/error-in-uploading-from-excel-sheet/m-p/2214143#M474626 <HTML><HEAD></HEAD><BODY><P>Hi Vignesh,</P><P></P><P>Plz use this function module.</P><P> CALL FUNCTION 'TEXT_CONVERT_XLS_TO_SAP'</P><P> EXPORTING</P><UL><LI level="1" type="ul"><P> I_FIELD_SEPERATOR =</P></LI></UL><P> i_line_header = 'X'</P><P> i_tab_raw_data = it_raw</P><P> i_filename = p_file1</P><P> TABLES</P><P> i_tab_converted_data = it_itab</P><P> EXCEPTIONS</P><P> conversion_failed = 1</P><P> OTHERS = 2.</P><P></P><P> IF sy-subrc &lt;&gt; 0.</P><P> MESSAGE ID sy-msgid TYPE sy-msgty NUMBER sy-msgno</P><P> WITH sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.</P><P></P><UL><UL><UL><UL><UL><UL><UL><UL><UL><LI level="9" type="ul"><P>Rewords some points .</P></LI></UL></UL></UL></UL></UL></UL></UL></UL></UL><P></P><P>Rgds,</P><P>P.Naganaja Reddy</P></BODY></HTML> Mon, 23 Apr 2007 06:23:27 GMT Former Member 2007-04-23T06:23:27Z error in uploading from excel sheet https://community.sap.com/t5/application-development-and-automation-discussions/error-in-uploading-from-excel-sheet/m-p/2214142#M474625 <HTML><HEAD></HEAD><BODY><P>i am working on sap crm so i am not able 2 use the fm ALSM_EXCEL_TO_INTERNAL_TABLE . i tried using gui_upload . it exists . wats should i give to the value for 'HAS_FIELD_SEPERATOR' in order to read from the excel file ?? i tried giving a tab space and it dumped my prog saying type conflict erroe while calling function module</P></BODY></HTML> Mon, 23 Apr 2007 06:20:59 GMT https://community.sap.com/t5/application-development-and-automation-discussions/error-in-uploading-from-excel-sheet/m-p/2214142#M474625 Former Member 2007-04-23T06:20:59Z Re: error in uploading from excel sheet https://community.sap.com/t5/application-development-and-automation-discussions/error-in-uploading-from-excel-sheet/m-p/2214143#M474626 <HTML><HEAD></HEAD><BODY><P>Hi Vignesh,</P><P></P><P>Plz use this function module.</P><P> CALL FUNCTION 'TEXT_CONVERT_XLS_TO_SAP'</P><P> EXPORTING</P><UL><LI level="1" type="ul"><P> I_FIELD_SEPERATOR =</P></LI></UL><P> i_line_header = 'X'</P><P> i_tab_raw_data = it_raw</P><P> i_filename = p_file1</P><P> TABLES</P><P> i_tab_converted_data = it_itab</P><P> EXCEPTIONS</P><P> conversion_failed = 1</P><P> OTHERS = 2.</P><P></P><P> IF sy-subrc &lt;&gt; 0.</P><P> MESSAGE ID sy-msgid TYPE sy-msgty NUMBER sy-msgno</P><P> WITH sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.</P><P></P><UL><UL><UL><UL><UL><UL><UL><UL><UL><LI level="9" type="ul"><P>Rewords some points .</P></LI></UL></UL></UL></UL></UL></UL></UL></UL></UL><P></P><P>Rgds,</P><P>P.Naganaja Reddy</P></BODY></HTML> Mon, 23 Apr 2007 06:23:27 GMT https://community.sap.com/t5/application-development-and-automation-discussions/error-in-uploading-from-excel-sheet/m-p/2214143#M474626 Former Member 2007-04-23T06:23:27Z