topic upload excel file in Application Development and Automation Discussions

upload excel file

Former Member — Thu, 12 Oct 2006 11:21:36 GMT

Hi all!

can anyone tell me how to upload the data containing 750 char( in single column )of an excel file into an internal table.

my requirement is to upload the data using bdc.

thanks in advance

susmita

Former Member — Thu, 12 Oct 2006 11:23:41 GMT

Use function module "GUI_UPLOAD"

Former Member — Thu, 12 Oct 2006 11:24:54 GMT

use GUI_UPLOAD AND TEXT_CONVERT_XLS_TO_SAP Functional Module

- Saru

Former Member — Thu, 12 Oct 2006 11:26:15 GMT

Try using this

*-- Internal table to upload file line by line

DATA : BEGIN OF t_text OCCURS 0,

line(750), " Flat file data

END OF t_text.

and use the FM GUI_UPLOAD

Madhavi