Database connection Issue?

  • 7 March 2023
  • 2 replies


How to connect database with automation anywhere using the connection string.

2 replies

Userlevel 5
Badge +14

@Vanitha Prasad  please find attached document.

Userlevel 7
Badge +13

Hi @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.