How to connect database with automation anywhere using the connection string.
Already have an account? Login
Login to the Pathfinder Community
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
@Vanitha Prasad ,
If you need to use Excel as DB, you need to have the Microsoft Access Database Engine 2010 Redistributable driver in order to use the Excel as Database. You can download the driver from below link. (I would suggest downloading 32-bit version rather than 64-bit)
When connecting to the data source, use the Database Connect action and set the Connection mode to Default.
In the connection string field, use the following as a template (enter the full path of your xlsx file as the Data Source parameter)
Provider=Microsoft.ACE.OLEDB.12.0;Data Source="full path to your xlsx file goes here";Extended Properties="Excel 12.0 Xml;HDR=YES"
Once the connection has been established, use the various database package actions to interact with your data.
You can also refer the below thread to get to know regarding this.