Excel type while uploading

[Former Member]

What is the File type used to upload Excel file into Internal table using WS_UPLOAD. apart from ASC.

Please help me.

[Former Member]

yes it is ASC

u can use ALSM_EXCEL_TO_INTERNAL_TABLE FM instead of that

and also chk TEXT_CONVERT_XLS_TO_SAP

Message was edited by:

Chandrasekhar Jagarlamudi

[Former Member]

Hi,

we can use ASC file type in FM UP_UPLOAD.

reaward if it helpful

Thanks

Vana

[Former Member]

Hi,

The other file type is 'DAT'.

You can save the excel file as Tab delimited flat file and with the above file type

you can upload the contents.

Reward if useful.

Thanks,

USR

[Former Member]

hi

'ASC' : ASCII file

The file is loaded line by line in the transferred table and this should

have one-column and be of the type C. The file size is returned in the

parameter FILELENGTH.

'TRU' : ASCII file + line wrap

If a line in a file does not fit into a row in a table, then the row is

filled completely, and the rest of the line is written to the next row

in the table. Words are not split, instead they are put into the next

row of the table.

'BIN' : Binary file

The file is loaded into the transferred table which should have

one-column and be of the type X. The table is filled line by line in

this case. In this case, the last line need not necessarily be

completely filled. For this reason, the parameter FILELENGTH must be

used during further processing. The table may be a maximum of 1022

characters 'wide'!

'DAT' : ASCII file with tab formatting

The file is loaded line by line into the transferred table. Tabs in the

file mean a change of field.

The file size is returned in the parameter FILELENGTH.

Reward points if helpful.

Regards

Nilesh

[Former Member]

Hi..

U can also use <b> .BIN</b> (binary file) and .DAT files also,

from SAP help..

File type (ASCII, binary ...)

Possible values

<b>'ASC' : ASCII file</b>

The file is loaded line by line in the transferred table and this should have one-column and be of the type C. The file size is returned in the parameter FILELENGTH.

<b>'TRU' : ASCII file + line wrap</b>

If a line in a file does not fit into a row in a table, then the row is filled completely, and the rest of the line is written to the next row in the table. Words are not split, instead they are put into the next row of the table.

<b>'BIN' : Binary file</b>

The file is loaded into the transferred table which should have one-column and be of the type X. The table is filled line by line in this case. In this case, the last line need not necessarily be completely filled. For this reason, the parameter FILELENGTH must be used during further processing. The table may be a maximum of 1022 characters 'wide'!

<b>'DAT' : ASCII file with tab formatting</b>

The file is loaded line by line into the transferred table. Tabs in the file mean a change of field.

The file size is returned in the parameter FILELENGTH.

[Former Member]

hi

good

default is ASC , you can give TXT also.

thanks

mrutyun^

[Former Member]

Hi,

File type is ASC. Check the following link:

http://www.sap-img.com/abap/upload-direct-excel.htm

Regards,

Bhaskar