How to convert Excel to Database and execute an sql query

Help Studio
, , ,
1

Hi Team,

can anyone help me how to convert a excel data to database and execute a query. Here my scenario is to identify the duplicate rows and write it in to different sheet, with SQL query.

Input:
Input

Expected output:
output

Input File
DATA.xlsx (8.4 KB)

Thanks.

1 Like
2

Hi @adarsh_kotagiri

This article might help you with your requirements:

Best Regards.

3 Likes
3

Hi @arjunshenoy
To remove duplicate rows, you can use ‘Remove Duplicate Rows’ activity.
To insert the data in a SQL table, use ‘UiPath.Database.Activities.InsertDataTable’ activity.

1 Like
4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.