Getting error while uploading data using the EXCEL( GUI_upload)

[Former Member]

Dear Freinds,

I am uploading data from my excel sheet to my Custom table . I am using the below code

call function 'GUI_UPLOAD'

exporting

filename = l_fn

filetype = 'BIN' "'ASC'

• has_field_separator = 'X'

tables

data_tab = p_i_ins_db

exceptions

others = 17.

i can see in my internal P_i_ins_db ...all the data is coming in encrypted format.

The flat given to me is the .CSV file .

Could any one please let me know how i can upload the data which is there in .csv file.

regards

syamala

[Former Member]

Hi,

Better use FM ALSM_EXCEL_TO_INTERNAL_TABLE.

Regards,

Atish

[Former Member]

Hi Atish Sarda

do you have peace of code where you have use th function module

ALSM_EXCEL_TO_INTERNAL_TABLE and further used the function module

GUI_UPLOAD .

Regards

syamla

[Former Member]

Hi,

You will find lots of sample code on wiki

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/abap/abap+general&;

Regards,

Atish

[Former Member]

Hi Syamala,

Before using the GUI_UPLOAD to upload the data from the excel file to the internal table,you can try usng the Function Module 'SAP_CONVERT_TO_TEX_FORMAT' or 'SAP_CONVERT_TO_CSV_FORMAT' as it helps n formatting the data.

In case you have any further clarifications,do let me know.

Regards,

Puneet Jhari.