i’m confused about the server names and all which it requires for the connection setup.
Page 1 / 1
Hi
To use Excel as a database in Automation Anywhere A360, follow these steps:
-
Install Microsoft Access Database Engine 2010:
-
Connect to Excel:
- Use the Database Connect action in A360, setting the connection mode to Default.
- In the connection string field, use this template:
ReplaceProvider=Microsoft.ACE.OLEDB.12.0;Data Source="full path to your xlsx file goes here";Extended Properties="Excel 12.0 Xml;HDR=YES"
"full path to your xlsx file goes here"
with the actual path to your Excel file.
-
Execute Queries:
Remember to adjust the connection string and ensure the necessary driver is installed. Happy automating!
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.