Learn how to create a task that reads a CSV file and quickly imports the contents and saves the output to an Excel file. This guided tutorial explains the actions required to set up this task. In this video you’ll learn how to:
- Locate the CSV file to import
- Create a dataset object to hold the contents of the CSV file
- Use the loop action to show how the CSV dataset can be imported one line at a time for data validation or database lookups
Watch this chapter now to learn how to get started.