topic how to upload data from excel file in BDC in Application Development and Automation Discussions

how to upload data from excel file in BDC

Former Member — Tue, 27 Nov 2007 18:31:40 GMT

hi experts !!

could you plz tell me how could i upload data from excel file in bdc.

if u give some sample code or example it will be better.

thanks in advance.

Former Member — Tue, 27 Nov 2007 18:39:36 GMT

By using ALSM_EXCEL_TO_INTERNAL_TABLE Fm you can read data from excel file and convert into itab..

then using this internal table write BDC code...

Former Member — Tue, 27 Nov 2007 18:40:56 GMT

You must upload the Excel file using GUI_UPLOAD (or the like).

Then process each row of the newly, filled-in internal table (with your screen values) and execute your t-code of choice.

Former Member — Tue, 27 Nov 2007 19:05:48 GMT

Hi,

you can use the function module ALSM_EXCEL_TO_INTERNAL_TABLE .

Check this thread for sample code.

Regards,

Maha