Data transfer.

[Former Member]

Hi experts,

I have a doubt, what is the easiest method to transfer data from .xls file into ztable(which was created by me). I have 3 fields in .xls file as well 3 fileds in my ztable.

Could you help, how i can i achieve this(with out bdc methods... etc.,)

Regards.

Vishnu.

[ferry_lianto]

Hi,

You can use the following FM to upload excel spreadsheets to an internal table then update the custom table from an internal table.

ALSM_EXCEL_TO_INTERNAL_TABLE

TEXT_CONVERT_XLS_TO_SAP

KCD_EXCEL_OLE_TO_INT_CONVERT

Also check these links for sample codes.

http://www.sapdevelopment.co.uk/file/file_upexcelalt2.htm

http://www.sapdevelopment.co.uk/file/file_upexcel.htm

http://www.sapdevelopment.co.uk/file/file_upexcelalt1.htm

Regards,

Ferry Lianto

[Former Member]

Hi,

Follow these steps:

1. Declare an internal table of type ztable.

2. Get the contents of the excel file into your internal table:

Use " ws_upload" or "ALSM_EXCEL_TO_INTERNAL_TABLE"

3. Insert the values in the internal table into your ztable.

Regards,

Vinod.