Please note: In this example program there is no error handling icnluded.
Write the name of the local text file into the field and run the report. Run the report (F8) and you will see an input text field. INSERT ZDE_EXAMPLE_TABLE FROM TABLE it_data.ĭESCRIBE TABLE it_data LINES l_table_count. WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4. MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO *&-*ĭata: it_data type standard table of ZDE_EXAMPLE_TABLE. Use report (GUI_UPLOAD) to import your file into the tableĬopy the following code into a new report (using transaction SE80). Your text file should look like this: 100 Germany XĢ. Save the data as text file with tab stops. In Excel prepare your data by considering the data structure of the table you want to import in. Now I want to import data from Excel in that table. In this example I have a simple table, named ZDE_EXAMPLE_TABLE, with the following structure:
Here is an easy way to import a local Excel (text) file into a table.
0 kommentar(er)
