couldn't connect to database using user defined method. Mysql database

Hi @Amit Poudel,

To use Excel as a database in Automation Anywhere A360, follow these steps:

1. Install Microsoft Access Database Engine 2010:

   • You’ll need the 32-bit version of the Microsoft Access Database Engine 2010 Redistributable driver installed on the bot-running device1. You can download it from here.

2. Connect to Excel:

   • Use the Database Connect action in A360, setting the connection mode to Default.
   • In the connection string field, use this template:

     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.

3. Execute Queries:

   • Utilize various database package actions to interact with your data, such as Export to data table with a SELECT statement2.

Remember to adjust the connection string and ensure the necessary driver is installed. Happy automating! 😊