The data file that will be used for input must have some kind of delimiter or separator. In most cases, you will...
By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
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