Skip to main content

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

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