GUI_UPOLOAD is not working for excel file

[Former Member]

Hi,

I am trying to upload the data from Excel using : GUI_UPLOAD, however, my internal table is getting filled with garbage values like ####.

Could you please help me out for the same.

I am working in CRM system, this system won't have ALSM function module.

Thanks,

Sandeep

[Former Member]

hi Sandeep,

You may use FM 'TEXT_CONVERT_XLS_TO_SAP ' check [Previous Post|;

Regards,

New SAP User

[Former Member]

Hi,

in CRM system, this FM is not available.

Thanks,

Sandeep

[former_member195402]

You can save your excel file as a .csv file. Then upload should work!

Regards,

Klaus

[Former Member]

Hi,

Try this post [;

Regards,

[former_member201275]

When you use GUI_UPLOAD you should have following setting:

has_field_separator = 'X'