topic Re: Data transfer. in Application Development and Automation Discussions

Data transfer.

Former Member — Tue, 03 Jul 2007 15:09:41 GMT

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.

Re: Data transfer.

ferry_lianto — Tue, 03 Jul 2007 15:12:02 GMT

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

Re: Data transfer.

Former Member — Tue, 03 Jul 2007 15:18:13 GMT

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.