Uploading excel with 48000 records into abap internal table
I am trying to upload an excel with 48000 records into abap internal (dynpro program) table through a Function Module, I used the following FM's
- GUI_UPLOAD: I tried this function modules by loading the excel as there is no restriction of no. of rows, but it does not process them properly and on further reading about this function module, I found out that it is not recommended to use this FM for uploading excel.
- TEXT_CONVERT_XLS_TO_SAP: Even for this FM, max rows specification is not required, but when loaded with the excel sent by the customer, it dumped as it could not handle the content of the excel.
- ZFAA_FILE_UPLOAD_EXCEL: I simply extended the no. of max rows in the original FM FAA_FILE_UPLOAD_EXCEL to 60,000 rows which is approximately the max number of rows provided by MS Excel 2003, and I was able to upload those many records (48,000). The FAA_FILE_UPLOAD_EXCEL uses the FM ALSM_EXCEL_TO_INTERNAL_TABLE for which the max no. of rows to be specified is mandatory.
But Sometimes the abap server might throw an exception of memory paging issue, I had observed this when I was uploading the 48000 records in the morning it got uploaded, but the same program when I ran in the afternoon, I got memory dumps. So I tried lowering the max rows and at 27000 records limit I was able to upload. So the abap system memory seems variable & is making me figure hard to set max rows value.
Can you kindly let me know which function module to use which could possibly load up these 48000 records into the database? Is there any basis based function module which I could explore for loading the excel?
Thanks & Regards,