Skip to Content
0
Nov 29, 2006 at 10:25 PM

Upload EXCEL to Internal Table

1604 Views

I have an excel sheet with more than 10000 entries. I have tried to use various function modules to upload them to ITAB. But most of the FM's just take first 10000 rows. Is there any solution for this ? I use sap 4.6 b & 4.6 c.

Here are some of the FMs I tried and failed :

/UBFNA/EXCEL_TO_ITAB

ALSM_EXCEL_TO_INTERNAL_TABLE

. Is there any way I can use GUI_UPLOAD to upload excel file with more than 10000 entries ? If so, what should be the Filetype parameter. I used DAT and WK1, the prog gives a dump. Thanks in advance.