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.
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..