topic Uploading data from EXCEL in Application Development and Automation Discussions

Uploading data from EXCEL

Former Member — Wed, 24 Sep 2008 22:36:58 GMT

Is any standard transaction to upload data from excel to a z table?

i mean, to avoid to make a zreport using gui_upload fm and then make the insert into the ztable?

Re: Uploading data from EXCEL

Former Member — Wed, 24 Sep 2008 22:40:37 GMT

Hello,

I think the only way is to create a maintenace view to your table and the create either a CATT or LSMW to upload the data to that table from the exel file....

but if you want I can submit a sample code to upload flat files to Z tables.

Bye,

Gabriel P.-

Re: Uploading data from EXCEL

Former Member — Thu, 25 Sep 2008 04:08:31 GMT

hi.....

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

thanks

nikita