Excel upload problem

[Former Member]

Hi Friends,

I am trying to upload data from Excel file to internal table using "GUI_UPLOAD". My SAP system is on low patch and it is not supporting any OLE FM to upload Excel into internal table.

I am facing problem whenever excel cell contain text with ',' or ". When I upload text contain those text, internal table will come with extra ".

Could you please suggest way to overcome?

Thanks & Regards

[Arun_Prabhu_K]

Hi Amit.

Try using the FM TEXT_CONVERT_XLS_TO_SAP for uploading data from Excel to Internal table.It works fine.

Cheers.

[former_member222709]

Hi Amit,

These are identifiers that are used by Excel. Hence, the simplest way to overcome this problem is to save your excel file as a 'Tab delimited text file' and upload the text file.

Regards,

Pranav.

[Former Member]

Dear amit,

try to use filetype 'dbf' then try to upload xls file.

[Former Member]

Hi

Try to save the excel file as MS 97-2003 version. Then use the FM "TEXT_CONVERT_XLS_TO_SAP" instead of GUI_UPLOAD.

[Former Member]

hi Amit,

use TEXT_CONVERT_XLS_TO_SAP FM. it will work fine. but plese take care it did't work for xlsx type of file so save your file in 2003 format and then uupload it.

Cheers,

Ankitesh

[Former Member]

Hi,

Try FM ALSM_EXCEL_TO_INTERNAL_TABLE to upload from Excel to Internal Table

Regards/Ali

[former_member187983]

Hi,

Can you use this funcation module alsm_excel_to_internal_table this funcational module work direct Excel to internal table please check .

Thanks & Regards

BRS

[former_member187983]

Hi,

Can you use this funcation module alsm_excel_to_internal_table this funcational module work direct Excel to internal table please check .

Thanks & Regards

BRS

[Former Member]

Hi,

Try this FM :

ALSM_EXCEL_TO_INTERNAL_TABLE

It will useful.

Ram.