The data file that will be used for input must have some kind of delimiter or separator. In most cases, you will find that comma-separated variable (.CSV) files are the best choice because they can be edited in Microsoft Excel. However, they also can be edited with a text editor such as Notepad. On the other hand, you can use a flat-file and a different field delimiter (e.g. the pipeline symbol "|").
Remember, the important thing is to make sure the correct data is in the correct columns and in the correct order.
CSV file being edited in Excel.
Flat-file separated by the | symbol.
AUTOMATING LINE-ITEM DATA ENTRY VIA SAPGUI
Step 1: Setting the stage
Step 2: Activating SAPGUI scripting
Step 3: Preparing the input data file
Step 4: Recording the data entry
Step 5: Analyzing the VBS script
Step 6: Automating the VBS script creation
Step 7: Running the VBS script program generator
Step 8: Playing the VBS script to enter the line items
Step 9: Troubleshooting
Review: Conclusion and more resources