Insert rows from another table

[Tormod_GK]

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 is added, but I don't want more columns. The two tables consists of four columns; Article, Date, UnitInStock, FullCost. So I would like to merge all rows into one table in the Query Editor.

[ankitpatira · Accepted solution]

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

[Tormod_GK]

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