It is doable but not super easy.
You read one into a datatable and then insert the rows from the other. Depending on the anount of data you might consefer using invoke code to speed things up
Alternatively you could try this package, i see they have a merge function