07-23-2008 3:57 PM
Could anyone give me the TCode for upload Excel file from Presentation Server to Appication Server.
I have tried with 'CG3Z'; but, some garbage values gets uploaded due to this.
If I try to upload Tab delimited file instead of Excel, it uploads correctly.
So, cann't we upload Excel directly.
Please let me know. waiting for ur replies.
Best Regards,
Prasad
07-23-2008 4:05 PM
May be you can see some # 's isn't it.
Upload some commad delimited or Tab delimited file
Save the excel file as Tab delimited or Comma delimited file(CSV)
and upload.
07-23-2008 4:05 PM
May be you can see some # 's isn't it.
Upload some commad delimited or Tab delimited file
Save the excel file as Tab delimited or Comma delimited file(CSV)
and upload.
07-23-2008 4:16 PM
Hi,
This is because the conversion to excel cannot be done when you store in the application server. So the only way you can store an excel file is by storing the file in the application server as a BIN file and not ASC file through CG3Z.
The reason for this is there is no application in the app server which can convert the OLE format to internal table. This will cause the program to dump.
Hope this clarifies your question.
Regards,
Hari
07-23-2008 4:19 PM
07-23-2008 5:18 PM
Hi Prasad,
please try function module ARCHIVFILE_CLIENT_TO_SERVER.
Regards,
Clemens
07-23-2008 10:16 PM
Hi,
Save the excel file as Tab delimited, and use the FM: GUI_UPLOAD.
DATA: i_file like rlgrap-filename value '/usr/sap/tmp/file.txt'.
DATA: begin of it_datatab occurs 0,
row(500) type c,
end of it_datatab.
CALL FUNCTION 'GUI_UPLOAD'
EXPORTING
filename = i_file
filetype = 'ASC'
has_field_separator = 'X'
TABLES
data_tab = it_datatab "ITBL_IN_RECORD[]
EXCEPTIONS
file_open_error = 1
OTHERS = 2.
Regards,
Bhaskar
08-05-2008 7:32 AM
Dear all,
Many thanks for all ur replies.
I have saved the Excel as TAB delimited file and uploaed on Appl. Service using standard Transaction 'CG3Z'.
sO, my problem is solved.
Thanks a lot agaian.
Kind Regards,
Prasad
03-25-2014 5:02 AM
Hi
I tried the T Code CG3Z but it says that T Code does not exists.
What should i do??
Madhu
08-05-2008 7:33 AM