Dear ABAP Gurus ,
Greetings for the Day Ahead !
I have a Requirement in which there are around 3 lakh rows in a excel file and having 4 columns to be uploaded in a internal table through ABAP programming .
My observations till today are that there are these Function Modules which can help me :
ALSM_EXCEL_TO_INTERNAL_TABLE--- Only 65536 rows can be uploaded in one go .
Plz correct me whereever i am wrong .
I think the behavior of first 2 FMs TEXT_CONVERT_XLS_TO_SAP & KCD_EXCEL_OLE_TO_INT_CONVERT is also similar regarding the no of rows limitation .
I want to know if this approach would be correct to accomplish this task .Approach is as follows :
1.Converting the excel file to Tab delimited text file by saving it .txt format by going in file option in excel .
2.Uploading it using GUI_UPLOAD using HAS_FIELD_SEPARATOR importing parameter of GUI_UPLOAD as 'X'.
Is this approach correct for uploading 3 Lakh Rows ?? Or should some other option should be tried ?
Once it is uploaded in internal table , i have to process the data to get concise rows according to logic which has been decided .
ABAP Gurus , I would be thankful if sample code is provided for my requirement of 3 lakh Rows as the requirement is urgent and timeline is tight .
Thanks in Advance .