cancel
Showing results for 
Search instead for 
Did you mean: 

Excel File Upload with 8 fields and 999 rows, 6th field with 1000+ characters

former_member769799
Discoverer
0 Kudos

Hi experts,

I have a requirement to upload excel file to SAP database. This excel file contains 8 fields and 999 rows. The 6th field may contain 1000+ characters.

I tried multiple FMs like GUI_UPLOAD, KCD_EXCEL_OLE_TO_INT_CONVERT, ALSM_EXCEL_TO_INTERNAL_TABLE custom configuration of ALSM_EXCEL_TO_INTERNAL_TABLE with value field of 1000 characters, nothing worked. Every time the database table's 6th field contains not more than 255 characters.

Please suggest solutions.

Thanks!

sveabecker
Community Advocate
Community Advocate
0 Kudos

Welcome and Thank you for visiting SAP Community to get answers to your questions. Please add more details to your question, e.g. you can also add a screenshot. With that, you can reach a broader range of experts to get your question answered. I also recommend to do this tutorial https://developers.sap.com/tutorials/community-qa.html

The more details you provide, the more likely it is that members will be able to assist you.

Finally, if you're hoping to connect with readers, please consider adding a picture to your profile. Here's how you do it: https://www.youtube.com/watch?v=F5JdUbyjfMA&list=PLpQebylHrdh5s3gwy-h6RtymfDpoz3vDS. By personalizing your profile with a photo of you, you encourage readers to respond.

Regards, Svea

SAP Community Global Moderator

Accepted Solutions (0)

Answers (1)

Answers (1)

abo
Active Contributor
0 Kudos

Seems like you could use abap2xlsx, the best kept secret in the whole abap developer community 😉

Specifically, you would want to start from ZDEMO_EXCEL15, which showcases the reader functionality.