topic code page when uploading xls files in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/code-page-when-uploading-xls-files/m-p/4637171#M1091776 <HTML><HEAD></HEAD><BODY><P>I am uploading an Excel file (extension xls) to update a SAP table in the DB.</P><P></P><P>The problem I face is that some characters are transformed when comparing the excel file and the sap table.</P><P></P><P>I assume this is related to code pages.</P><P></P><P>I would like to solve during running time of the ABAP the following:</P><P></P><P>a) find code page use for the xls file</P><P>b) find code page used by my abap system</P><P>c) translate from one to another</P><P></P><P>If not all possible/easy I could "hardcode" the code code page of my system. Second I could "harcode" the code page of the excel file, it means fix the code page used by the user creating this file.</P><P></P><P>Regards</P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P>PS To upload the file I use: CALL FUNCTION 'TEXT_CONVERT_XLS_TO_SAP'</P></BODY></HTML> Wed, 22 Oct 2008 13:39:09 GMT Former Member 2008-10-22T13:39:09Z code page when uploading xls files https://community.sap.com/t5/application-development-and-automation-discussions/code-page-when-uploading-xls-files/m-p/4637171#M1091776 <HTML><HEAD></HEAD><BODY><P>I am uploading an Excel file (extension xls) to update a SAP table in the DB.</P><P></P><P>The problem I face is that some characters are transformed when comparing the excel file and the sap table.</P><P></P><P>I assume this is related to code pages.</P><P></P><P>I would like to solve during running time of the ABAP the following:</P><P></P><P>a) find code page use for the xls file</P><P>b) find code page used by my abap system</P><P>c) translate from one to another</P><P></P><P>If not all possible/easy I could "hardcode" the code code page of my system. Second I could "harcode" the code page of the excel file, it means fix the code page used by the user creating this file.</P><P></P><P>Regards</P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P>PS To upload the file I use: CALL FUNCTION 'TEXT_CONVERT_XLS_TO_SAP'</P></BODY></HTML> Wed, 22 Oct 2008 13:39:09 GMT https://community.sap.com/t5/application-development-and-automation-discussions/code-page-when-uploading-xls-files/m-p/4637171#M1091776 Former Member 2008-10-22T13:39:09Z Re: code page when uploading xls files https://community.sap.com/t5/application-development-and-automation-discussions/code-page-when-uploading-xls-files/m-p/4637172#M1091777 <HTML><HEAD></HEAD><BODY><P>Try using FM <STRONG>SCP_CODEPAGE_BY_EXTERNAL_NAME</STRONG></P></BODY></HTML> Wed, 22 Oct 2008 13:52:18 GMT https://community.sap.com/t5/application-development-and-automation-discussions/code-page-when-uploading-xls-files/m-p/4637172#M1091777 MarcinPciak 2008-10-22T13:52:18Z