Database query issue

How i should insert data from one database table to another database table which is having same column names.

1 Like

Hi
Welcome to uipath community
—yah that’s possible
But for that first we need to install the database package
For that go to design tab in the studio and click in Manage Packages → Official tab → search as UiPath.Database.Activities and install it
—once after installing use EXECUTE Query activity and get the datatable variable named as dt as output with a SELECT SQL Statement
—then we can use INSERT activity where pass this variable dt as input and mention the database the table as well as a string between double quotes

But before we need to configure the connection with our database server and that can be done in these two activities itself with CONNECTION WIZARD option

Hope this would help you
Kindly try this and let know for any queries or clarification
Cheers @Gauri_R

1 Like

Thanks A lot…i done with query using execute query activity…

“INSERT INTO target_table(col1,…)
SELECT col1,…
FROM source_database_source_table”

2 Likes

Cheers @Gauri_R

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