Forum Discussion

Tormod_GK's avatar
Tormod_GK
Frequent Visitor
9 years ago
Solved

Insert rows from another table

Hi.   This might be simple, but I don't know how to do this.   I have two facttables with similar data where I want data from one table to be inserted in the other. When I do a merge the columns ...
  • ankitpatira's avatar
    ankitpatira
    9 years ago

    Tormod_GK Instead of Merge use Append Queries and make sure column names are same in both the tables.

ankitpatira's avatar
ankitpatira
Community Champion
9 years ago

Tormod_GK Instead of Merge use Append Queries and make sure column names are same in both the tables.

Tormod_GK's avatar
Tormod_GK
Frequent Visitor
9 years ago

Thanx! I did try append queries, but the clue here (as you mentioned) was to rename the columns so they were the same.