Skip to Content
0
Former Member
Sep 11, 2007 at 09:05 AM

uploading an excel file in an internal table.

22 Views

hi experts,

I m trying to upload a excel file comprising of 16,000 records using the function module 'ALSM_EXCEL_TO_INTERNAL_TABLE' as follws

CALL FUNCTION 'ALSM_EXCEL_TO_INTERNAL_TABLE'

EXPORTING

filename = p_input

i_begin_col = 1

i_begin_row = 1

i_end_col = 30

i_end_row = 65000

TABLES

intern = g_t_excel

EXCEPTIONS

inconsistent_parameters = 1

upload_ole = 2

OTHERS = 3.

IF sy-subrc <> 0.

MESSAGE ID sy-msgid TYPE sy-msgty NUMBER sy-msgno

WITH sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.

ENDIF.

My problem is I am unable to upload record number 10001 else all the records are uploaded successfully

can anyone help me in solving this problem