Sql query output and excel

I want to paste the data from the result of query in sql server to an excel.Afterwards i need to filter that data in excel…So how to make automation of all this using uipath? Any earliest help would be much appreciable. Thanks.

Regards,
Asit

  1. Sql Connect Activity
  2. Execute Query Activity → Output to Datatable
    3)) Sql Disconnect Activity
  3. FIlter your Datatable (than in Excel)
  4. Write Range activity to Write to Excel. (you can filter here also)

vvaidya, can you elaborate with pictures in your comment. i am having hard time to perform this

1 Like