How i should insert data from one database table to another database table which is having same column names.
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
Thanks A lot…i done with query using execute query activity…
“INSERT INTO target_table(col1,…)
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.