T19 - Migrate/Export data from Database to CSV |
Task Description |
Query the database and transfer that data to CSV file.
 T19.atmn  T19MyDB.mdb
Note: Save the .atmn file in My Documents -> Automation Anywhere -> Automation Anywhere -> My Tasks
|
| Solutions |
 |
Open Task Editor to create a new task
- Click on New -> Task Editor
|
Screenshot 1
Screenshot 2 |
 |
Connect to the database
- Using 'Database:Connect' command, specify the connection string to connect to the source Database with Session Name, Default. Connect to '<database connection string>' Session: 'Default'.
Connect to '<database connection string>.
|
 |
Get data from the database and Export it to CSV
- Double click Database command from the Application category, select SQL Query Option and specify a Select SQL Statement using 'Default' session.
- Enable option, Export Data to CSV and in ‘File Path’ field specify the CSV file path. Screenshot1
|
 |
How to run the task:
- In case you do not have Automation Anywhere installed, please download and install it from, http://www.automationanywhere.com/download/freeTrial.htm
- Save T19.atmn under location, My Documents\Automation Anywhere\Automation Anywhere\My Tasks
- Save T19MyDB.mdb under C:\.
- Launch Automation Anywhere and from Task List select T19.atmn and click on RUN button to run the task.
|
|
|
| When you run this task, it reads the data from source database and exports it into C:\OrderMaster.csv file. |
|
 |
| 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 >> |
|
