12-15-2011 8:24 AM
Hi all,
I need to put an excel test file in one directory DIR_TEMP in AL11.
I use t-code CG3z to upload the excel file. I tried using both transfer format "BIN" as well as "ASC".
Basically the excel file contains 1 header and i line of information as below:
PERNR NAME SUBTY BEGDA ENDDA ANZHL BETRG ZEINH ZUORD
8000001 Test Employee 2154 8/1/2011 12/31/9999 800 F888
I manage to upload it but when I open the file in AL11, I am getting gibberish characters:
PK##########!#q#9+p### #####Û#[Content_Types].xml ¢×#( ####################################################################################################################################
P#TÒ##DQ4ï½ùfìé [#d##µ³9#g####Ni»ÌÙëËCzÍ##Â*a###í#Ù v~6}ÙyÀ#ª-æ¬#Ñßp#²#J`æ<XúS¸P#H#aɽ#+±#>##®¸t6##i¬5ØlúD##V#,D##¢"#¾5<#
For your further info, I tried saving as .dat and .csv/ and also .xls but no avail.
Anyone knows anything about this?
12-15-2011 8:40 AM
When u uploaded the file did u remove WORDWRAP from the file and uploaded ! sometimes the End of the record will be present in the wrong place