RPA | Automation Anywhere - A360 Tutorial | Excel As Database | Real-Time Project

This RPA Automation Anywhere A360 tutorial helps people interested in learning robotic process automation and automation anywhere A360.

In This Automation Anywhere tutorial video, we are explaining excel as a database in automation anywhere with A360 Database Package.

In this A360 tutorial below Topics are Covered:

1. how to connect database in automation anywhere
2. Select Query to Store the Data to CSV
3. Select Query to Access the Data with Loop
4. Update Query to Update the Data In Excel File
5. Select Query with Where Clause
6. Update Query with Where Clause
7. connection string for excel as a database in automation anywhere

Contact us for Automation Anywhere Projects, Automation Anywhere Tutorial and Automation Anywhere Interview Questions.

DB Connection String and Queries:

select * from [VIPlans$$]
update [Student Details$$] set Hobbies = 'Nothing' where Hobbies='dancing'

#rpa #automation #a360 #automationanywhere #automation360

[TechSuccessors]

DB Connection String and Queries:
Properties="Excel 12.0 Xml;HDR=YES";

select * from [VIPlans$$]
update [Student Details$$] set Hobbies = 'Nothing' where Hobbies='dancing'

[smartstudent]

Please explain stored procedure as well

[muralikrishna]

Do we need to install java and JDBC Driver before this ?