code page when uploading xls files

[Former Member]

I am uploading an Excel file (extension xls) to update a SAP table in the DB.

The problem I face is that some characters are transformed when comparing the excel file and the sap table.

I assume this is related to code pages.

I would like to solve during running time of the ABAP the following:

a) find code page use for the xls file

b) find code page used by my abap system

c) translate from one to another

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.

Regards

PS To upload the file I use: CALL FUNCTION 'TEXT_CONVERT_XLS_TO_SAP'

[MarcinPciak]

Try using FM SCP_CODEPAGE_BY_EXTERNAL_NAME