topic Getting error while uploading data using the EXCEL( GUI_upload) in Application Development and Automation Discussions

Getting error while uploading data using the EXCEL( GUI_upload)

Former Member — Tue, 16 Oct 2007 04:14:12 GMT

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

Re: Getting error while uploading data using the EXCEL( GUI_upload)

Former Member — Tue, 16 Oct 2007 04:15:22 GMT

Hi,

Better use FM ALSM_EXCEL_TO_INTERNAL_TABLE.

Regards,

Atish

Re: Getting error while uploading data using the EXCEL( GUI_upload)

Former Member — Tue, 16 Oct 2007 05:00:19 GMT

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.

Re: Getting error while uploading data using the EXCEL( GUI_upload)

Former Member — Tue, 16 Oct 2007 06:32:58 GMT

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

Re: Getting error while uploading data using the EXCEL( GUI_upload)

Former Member — Tue, 16 Oct 2007 06:49:36 GMT

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