Uploading Data From Excel Sheet to SAP Database Tables
We are having an Excel Sheet with 90 different columns. Now we want only 2 of the columns to be uploaded in the database tables. So, Plz tell me which function module will be suitable for this. And plz help me with the code also.
Satesh R replied
As suggested you can use ALSM_EXCEL_TO_INTERNAL_TABLE..
specify the filename..
the return internal table of type ALSMEX_TABLINE
WHICH HAS A FIELD <b>COL</b> which indicates the column
just loop at that itab chack if COL is <= 2 and put it into another itab..
this will have only first 2 columns from the excel..
if you dont get it .. just reply i'll get some sample code..