query

  1. P

    Run Access queries on Blue Prism

    Hi, fellows! I'm working on automating a process that needs to run some queries in Access (based on a Form with the necessary sequence of queries). How can I teach this Form to the robot through the Data - OLEDB object? Is this possible? Image 1 - Queries Image 2 - VBA with the Forms...
  2. T

    Microsoft Excel Data Connections - Alter Command Text

    Hi everyone, I'm trying to change Command Text box in Connection Properties (see picture). It is an existing data connection in Excel and I need to change the query. I already found this thread discussing altering Connection String but I was not able to alter the code for my purposes. What...
  3. P

    Update query

    Hi , Did any one tried update query in Oledb-execute action? Please reply here. I am getting error while using it. Iam trying to update a column in excel using oledb. Pls help Thanks
  4. P

    Update Column in Excel using OLEDB

    Hi Did any one use Update query to update column with a formula in Excel, Excel was like 160K Rows of data, SO it taking time to update using other ways , Pls help me out if any one did update query , I am trying but getting error , my connection string was correct (as tested using get...
  5. M

    OLEDB - Get collection

    Hi All, When I tried to connect the OLEDB for one of my process, its working fine(its nearly 50 rows of data as output). But for another process its not working. while running its take sometime and throwing the error. (while manually the result is having only 10 rows output). its showing the...
  6. P

    I am using Workfusion Facing issue with slowness

    hello RPA developers, i am using WorkFusion RPA Express but facing issue with slow processing in software it takes lots time to Read single document. and overall process is much time consuming than other software like Uipath. need some help, how can this issue be fixed contact...
Top