Skip to Content

Why am I seeing weird characters in AL11 excel file

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?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Dec 15, 2011 at 08: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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.