file type used in bdc

[Former Member]

if i have data in excel format which i save it into tab delimited format then in gui_upload which file type i have to used?

or if i have data in word format which i save in it into tab delimited format then in gui_upload which file type i have to used?

Can any one help me?

Thanks,

Vishal Bhagwat.

[Former Member]

Hi,

Save it as tab delimeted using the save as

it will be of tab delimeted

Regards

Shiva

[Former Member]

Hi shiva,

Thanks but i have prob in gui_upload fn i have data in excel i save it as tab delimited but which file type is used in gui_upload is 'ASC' or any other type.

Thanks

Vishal bhagwat.

[Former Member]

hi

the file type is ASC

Use FM ALSM_EXCEL_TO_INTERNAL_TABLE

TYPES:

BEGIN OF ty_upload,

field1 TYPE c length 12,

field2 TYPE c length 12,

field3 TYPE c length 12,

END OF ty_upload.

DATA it_upload TYPE STANDARD TABLE OF ty_upload WITH DEFAULT KEY.

DATA wa_upload TYPE ty_upload.

DATA itab TYPE STANDARD TABLE OF alsmex_tabline WITH DEFAULT KEY.

FIELD-SYMBOLS: <wa> type alsmex_tabline.

CALL FUNCTION 'ALSM_EXCEL_TO_INTERNAL_TABLE'

EXPORTING

filename = filename

i_begin_col = 1

i_begin_row = 1

i_end_col = 3

i_end_row = 65535

TABLES

intern = itab.

LOOP AT itab ASSIGNING <wa>.

CASE <wa>-col.

WHEN '0001'.

wa_upload-field1 = <wa>-value.

WHEN '0002'.

wa_upload-field2 = <wa>-value.

WHEN '0003'.

wa_upload-field3 = <wa>-value.

ENDCASE.

APPEND wa_upload TO it_upload.

CLEAR wa_upload.

ENDLOOP.

Reward if usefull

[Former Member]

hello Vishal,

select file type as 'ASC' but then select HAS_FIELD_SEPARATOR to 'X'

or use 'DAT' format which is exclusive for tab deliminated data.

Hope this will answer your doubt. reward points if useful.

Rushikesh

[Former Member]

Hi Rushikesh,

Thank's for sol'n My prob was solved. but i have one query that if we have data in word format then is it nessesary to save this file in tab delimited or keep the file as it is.

Thanks,

Regards,

Vishal Bhagwat.