how to upload data from excel file in BDC

[Former Member]

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]

Hi

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]

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]

Hi,

you can use the function module ALSM_EXCEL_TO_INTERNAL_TABLE .

Check this thread for sample code.

Regards,

Maha