topic upload bdc from excel in Application Development and Automation Discussions

upload bdc from excel

Former Member — Tue, 06 Apr 2010 07:37:02 GMT

Hi Experts,

i am ding work with BDC. wen i am taking data from txt file my program is working fine.

but i want to know how can i use excel file insted of txt file.

if i want to convert my excel file in cvs format then how is it poosible.

Plz give me the code.

thx in advance.

Re: upload bdc from excel

Former Member — Tue, 06 Apr 2010 07:42:52 GMT

Use FM 'TEXT_CONVERT_XLS_TO_SAP' for uploading from excel

For downloading use FM 'GUI_DOWNLOAD' with seperator 'comma' and file extension CSV.

Regards

Murthy .M

Re: upload bdc from excel

ThomasZloch — Tue, 06 Apr 2010 07:42:59 GMT

Please search before posting, also don't expect complete code to be handed over, do your work and just ask specific questions (that have not been asked and answered before).

Thread locked.

Thomas