Here is something I quickly set up by creating a Sample Access Database. The SQL Query to insert data into a table looks something like this.
In your case you have to replace all the values to be inserted in the SELECT statement with values you have pulled from your source table.
In addition you don’t have to have the FROM CLAUSE in the SELECT statement because you will be inserting straight up values from your source table.
Therefore, with string operations, if you have your automation build a query using the values retrieved from each row of the source table, each insert SQL would translate to something like this:
insert into MY_TARGET_TABLE(column1, column2, column3)
SELECT 'Column1 value', 'column2 value', 123
Alternately, you may craft the SQL this way as well. T-SQL supports it as far as I know.
insert into MY_TARGET_TABLE(column1, column2, column3)
VALUES('Column1 value', 'column2 value', 123)
You have to go through the SQL library documentation for UiPath to see how to pass this SQL via UiPath SQL Library. This is the package normally used.
I hope this gets you going.
Thanks