Tables and Excel

[Former Member]

Hello Experts,

Can anyone tell me in detail how to proceed with the following requirement.

I have 2 excel sheets containing 40,000 records each.

1st Excel - ZZPROJ.

Columns - Mandant; Projalt C40, Projneu C40.

2nd Excel - ZZPRPS.

Columns - Mandant; PSPalt C40, PSPneu C40.

and Finally

Program to read the files into the tables.

PS - Points will be awarded.

Thanks,

Varun

[Former Member]

Hi Varun,

Please check this link

Uploading multiple multitab Excel sheets or Ranges from Front end to SAP

http://www.sap-img.com/abap/uploading-multiple-multitab-excel-sheets-or-ranges.htm

Best regards,

raam

[Former Member]

Hi,

You can use the function module 'WS_EXCEL' to upload data from excel to a internal table.

[Former Member]

hiii

you can upload data from excel sheet to internal table by using following FM

CALL FUNCTION 'ALSM_EXCEL_TO_INTERNAL_TABLE'
    EXPORTING
      filename                = p_pfile
      i_begin_col             = 1
      i_begin_row             = 2
      i_end_col               = 13
      i_end_row               = 8
    TABLES
      intern                  = it_excel
    EXCEPTIONS
      inconsistent_parameters = 1
      upload_ole              = 2
      OTHERS                  = 3.

after getting data into an internal tabel you can insert it into your table..

i hope it helps you.

regards

twinkal