CSV import - Automation Anywhere Example. The Automation Software.

Call: 1-888-484-3535

Home > Product > Solutions > Data Integration / Data Automation > T16

T16 - Import csv file

Task Description

Import csv file and insert values in database.

Solutions

To see how the task runs in Automation Anywhere, download the files.

T16.atmn

myCSV.csv

Note: Save the xls in C: drive, the .atmn file in My Documents -> Automation Anywhere -> Automation Anywhere -> My Tasks

	Open Task Editor to create a new task Click on New->Task Editor	Screenshot 1 Screenshot 2
	Import csv file Select the 'Database' command. Select the 'Read From CSV File' command. Select the csv file that you want to import. Screenshot 1. You can read a comma or tab delimited csv file with this command. Read From CSV file: 'C:\myCSV.csv' Delimiter: 'Comma' Header: 'No'
	Connect to the database Using the 'Database' command, specify the connection string to connect to the database.
	Process csv file Let's process the values of csv file one by one. All the values of the csv file in one line will be read using Loop 'Each row in a SQL query dataset'. In the loop we have insert SQL statement which inserts each read value into the database. The complete task would look as shown in Screenshot 2.

When you run this task, it reads the values from a csv file and inserts them one by one into the database.

Next Steps
	Buy now
	Download free trial
	Compare versions
	Watch a flash demo
	Contact me
	Ask the Expert
	Request live demo

Call 1-888-484-3535

Our Customers

We started using this product to copy data from legacy system to new system. Now we use it just to do about anything automated. Countless hours saved. Thank you guys.

- Jack Greenberg

Read Customer Testimonies >>

Products Download Purchase Services Support Customers Company Sitemap Trademark