Question

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

  • 12 June 2024
  • 1 reply
  • 16 views

Badge +1

i’m confused about the server names and all which it requires for the connection setup.


1 reply

Userlevel 1
Badge +3

Hi @Amit Poudel,

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

  1. Install Microsoft Access Database Engine 2010:

  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:

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

 

Reply