
i’m confused about the server names and all which it requires for the connection setup.
i’m confused about the server names and all which it requires for the connection setup.
Hi
To use Excel as a database in Automation Anywhere A360, follow these steps:
Install Microsoft Access Database Engine 2010:
Connect to Excel:
Provider=Microsoft.ACE.OLEDB.12.0;Data Source="full path to your xlsx file goes here";Extended Properties="Excel 12.0 Xml;HDR=YES"
Replace "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!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.