READ DATA

[Former Member]

Can we read data horizontally(in an excel Sheet) through a BDCprogram??

Please help me out

Thanks in advance.

[Former Member]

Hi,

we can using a functional module TEXT_CONVERT_XLS_TO_SAP which will get the data from excel into sap.

<REMOVED BY MODERATOR>

Edited by: Alvaro Tejada Galindo on Apr 23, 2008 5:15 PM

[Former Member]

Another FM.

ALSM_EXCEL_TO_INTERNAL_TABLE

This FM reads each and every Cell of Excel step by step.

A

[Former Member]

hi Malloc Lee ,

use function module ALSM_EXCEL_TO_INTERNAL_TABLE

it reads the data horizontally only.

<REMOVED BY MODERATOR>

Thanks and regards.

Rajeshwar.

Edited by: Alvaro Tejada Galindo on Apr 23, 2008 5:16 PM

[Former Member]

hi,

1) Use the function module:ALSM_EXCEL_TO_INTERNAL_TABLE.

2) specify the file location.

3) enter the row and the column where the data is starting, in the excel.

4) we can avoid the header row and column, if the excel has any header.

5) this funciton module reads the data horizontally.

Thanks

Anitha T S

[Former Member]

Save the excel file as a text file.

Then your progr can read it in and populate an internal table.

[Former Member]

Save the excel file as a text file.

Then your progr can read it in and populate an internal table.