Question

Database connection Issue?

  • 7 March 2023
  • 2 replies
  • 93 views

Badge

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


2 replies

Userlevel 5
Badge +10

@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) 
 

https://www.microsoft.com/en-us/download/details.aspx?id=13255

 

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.

 

 

Reply