Upload Server SAP Excel to SAP

[Former Member]

Hi gurus,

I have an Excel file into Server SAP, specifically in /excels/test.xls. In transaction AL11 I can see the excel. Besides of this, I programmed a function that upload the excel in an internal sap table. I use 'TEXT_CONVERT_XLS_TO_SAP' and it is necessary run in background. If I run function in SAP Bussines Connector I receive and error CNTL_ERROR. If I run function with SAP GUI I receive a message file not exists or it can't be managed and, finally, If I choose an excel from my laptop, from my desktop the functions runs OK.

I don't understand what happens, I thought it was easier jejeje!

Thank you a lot!

I will revvard answers!

[former_member376453]

You have to read data from application server with OPEN dataset. The FM you are using, is for uploading data from Presentation server.

Kuntal

[Former Member]

HI,

The FM TEXT_CONVERT_XLS_TO_SAP tris to upload the data from the presentation server. This cannot be executed in the foreground.

If you want to read the data from the application server then you need to use the OPEN DATASET in INPUT MODE and using ReafD statement read the data from the application server to the internal table.

You can use the tcode CG3Z CG3Y to upload the data from the presentaion server to application server and using the dataset statement read the data in the program.

Edited by: Avinash Kodarapu on Mar 9, 2009 11:04 PM

[former_member156446]

Refer to this threads: