uploading data from excel sheet

[Former Member]

HI,

Can anyone provide me the details to upload vendor data from excel sheet to database through bdc?

Thankyou.

[Former Member]

HI,

Can anyone provide me the details to upload vendor data from excel sheet to database through bdc?

Thankyou.

[Former Member]

upload the excel file in your internal table and then use BDC to updated the database table.

FM's to upload Excel:

GUI_UPLOAD

KCD_EXCEL_OLE_TO_INT_CONVERT

ALSM_EXCEL_TO_INTERNALTABLE

refer to the link:

http://diocio.wordpress.com/2007/02/12/sap-upload-excel-document-into-internal-table-2/

http://www.sap-img.com/abap/learning-bdc-programming.htm

With luck,

Pritam.